So I was brought into a problem yesterday at a client where replication hadn’t been working for a few days. It’s a straight forward SQL 2005 sp2 transactional replication setup with no special filters, just replicates 35 articles. However as it had been down for a few days a new snapshot had to be generated. [...]
|
||||||
|
Well it’s been about 6 weeks since the last Cumulative Update so it must be time for a new one. So as of today (6/16/08) we now have 8 Cumulative Updates for SQL 2005 SP2 which you can get here. I haven’t downloaded it yet, but I can tell you that I can’t wait until [...] SELECT sder.session_id AS [SPID], sdes.login_name AS [Login], sd.name AS [DBName], sder.start_time AS [Start Time], sder.status AS [Status], sder.command AS [Command], sdet.text AS [SQL Text], sder.percent_complete AS [Pct Cmplt], sder.estimated_completion_time AS [Est Cmplt Time], sder.wait_type AS [Wait], sder.wait_time AS [Wait Time], sder.last_wait_type AS [Last Wait], sder.cpu_time AS [CPU Time], sder.total_elapsed_time AS [Total Elpsd Time], sder.reads AS [...] |
||||||
|
Copyright © 2010 Aaron Lowe - All Rights Reserved |
||||||