Good fix SSC. I dont see how the author's code can work. He is erroneously referring to column aliases in the select statement. These aliases are not...

This makes documentation as easy as it can be and stores it in a logical place that anyone can find.

Thanks!

Got it. Thanks Bill. 🙂

I can only run this script from master else I get the following error.

How do I...

I agree Matt. This is what I use in my triggers to see if a change has actually occurred.

IF EXISTS (SELECT *

...

Interesting idea. Why is this better than using the "Reorganize Index Task" in the Maintenance Plan?

Thank you all for your replies. We do research and the purpose of the export is to have a text only archive of the data available in addition to...

Yes, I guess I do mean to export the data. We have an old VB script that exports all the data and objects once a week. This is...

The XML output version of this script is so crisp and clean, I love it!

What would make this output more useful to me is if there was a way to...

Just like shown here:

http://www.mssqltips.com/sqlservertip/2859/evaluating-policies-on-multiple-sql-server-instances-using-central-management-server/

Chauchs,

I am not sure if I understand your reply. Are you suggesting I add the central management server to the sysmanagement_shared_server_groups table? I tried adding it via...

Oooo. I do have SQL Prompt 5. That addin does change the behaviour a bit. I wonder...:-)

No laptop, but I have been there and that can be frustrating.

Love the Magoo avatar. Haven't seen him in ages! :hehe:

I have lots of applications open: MS Mail 2010, MS Paint, Chrome, a text editor, etc... I see where you are going with this so I can try to...

You are 100% correct. The lock showed up just like in your image. Very interesting. Thanks for taking the time to teach me something. 😎