Ok I know adding [] works, however debugging some code I see this:

set @execsql = 'alter login ' + @logname + ' disable'

The code returns invalid sytanx error at...

Thanks for a very good overview. Also for the reminder that the exams do not cover R2.

Good job, like the results. Thanks

Good question to jog the memory, keep them coming:-D:-D

This works, remember to get your database id first. Good tool to help identify fragmented indexes.

see http://msdn.microsoft.com/en-us/library/ms186274.aspx

Interesting when I go to the article from this post everything shows, when I go to it from the scripts directory nothing is in it.

This would be an interesting entry, however the article is empty, there is no script attached