SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2010

Error Configuring DataCollector: A collection set cannot start without a schedule

Data Collection, Puppy Style

Update: Based on Bill Ramos’ comment below and a note on Twitter (thanks!!) I have added some more details which hopefully make the situation clearer.


When setting up data collection using the GUI, configuration failed halfway through setup. At the point  of failure I… Read more

2 comments, 1,411 reads

Posted in LittleKendra on 26 June 2010

Change Data Capture vs Change Tracking

Make sure to check out the comments on this one!

A short conversation on Twitter Monday night reminded me of this topic. SQL 2008 introduced two new features with similar names and similar-sounding functionality, which are actually quite different. I had learned about these once upon a time and then… Read more

0 comments, 627 reads

Posted in LittleKendra on 23 June 2010