Interesting items on comments. I tend to avoid comments unless things are complex, so the part about writing one when you think more than 5 minutes makes some sense to...

I'd like to get a cloud up there and thanks for the comments.

I think it would look funny as I haven't done a great job of tagging things outside of...

My guess is that SET FORCEPLAN on is a setting, but likely people writing Books Online are having trouble coordinating things with the product so large.

I'll award points back and...

Lynn's method filters out the rows with NULLs, and that's how you should check for null. Don't use = NULL or !NULL, use IS NULL or IS NOT NULL.

If you...

I've pinged a few people on this.

If you lost your DC, anything requiring AD would not work. I might also post here: http://forums.microsoft.com/TechNet/ShowForum.aspx?ForumID=581&SiteID=17

You can do this on either side, but pulling the entire table over every few minutes and then comparing with what's in SQL Server will end up with a lot...

I'd use Logon triggers as Jack suggested.

People usually do this in stored procedures to be sure extraneous messages are not necessarily sent to the client.

Typically this doesn't have a huge effect.

What are the data types and error?

If you check the error log what name is listed?

If I understand, you changed the Windows host name, correct? What was it and what is it? Then what did you...

I would think this error is occuring on the server which you are connecting to. Not from. I'd monitor that one, or check the network and make sure that you...

Arguably not the best question or answer. Hints are an area that I think SQL is a little immature in how to describe/explain them. Please feel free to post suggestions...

Not sure when it was removed, but it's not in 2005 for sure.

I've always had trouble with maintenance plans once I edited them in BIDS. After that point, I've managed them as normal SSIS packages, not plans anymore.

If you do the stats before detaching, you shouldn't have to do it again.

What do you mean stats for the entire db? Where else is there data other than in...