thank you for the link, one more question, how do you compare/synchronize databases on remote server?

Michael,

I'll take that in consideration, thank you so much for your suggestion.

Hilda

I had a gut feeling that was going to be the answer but I'm relatively new DBA and wasn't sure.

Thank you for your feedback. I'll talk to my network...

I think you should be fine since it's SP2 not SP1 (pre 10.50.2796.0)

Markus,

We're running SQL Server 2008 R2 SP1, it works good on this one, I believe the problem is on earlier versions.

🙂

Tacky, tacky. This is good and I'll take the criticism openly "John Doe". After all that's why this is in a open forum.

Indeed it is.

Andrew,

Besides the problem mentioned in the article, everything else went smooth. The upgrade was almost perfect. As a DBA you always experience and heard so many different problems...

Not picky at all. Writing for an audience in my opinion is not an easy task. Most time I tend to forget that the reader may not and...

HildaJ (8/13/2013)

--------------------------------------------------------------------------------

However, if I removed this option how am I suppose to repair any errors if found? I guess manually?

By restoring a clean backup. Repair is usually a last...

I'm glad I ran into your article, we have several assemblies in our sql server it was nice to see how the process is captured step by step.

Thank you.

Very interesting indeed. I unselected the option and run it tonight and see what happens. However, if I removed this option how am I suppose to repair any...

I'm creating a maintenance plan to check database integrity through SQL Server Enterprise manager, please see attached images.

You can't set master to single user mode and you don't need single user mode to run a normal checkDB.

I'm running SQL Server 2000 and according to the error log...

This article is right on, technology keeps moving it's like time, it doesn't wait for anyone it's in constanst move. I finished my last class this summer before I...