Hello Leon,

Thanks for the excellent tip/modification. I will test your code and then modify my reports with this additional information. Thanks!!

Does this code produce the same information on SQL...

I've written a few articles and believe me it's a great feeling to see the feed back you get. Sometime good sometimes bad but I feel that either way you...

Toby,

I think many people here would love to see and use your tool. I would. Sometime you need just need a solution like yours. So I'm hoping to encourage you...

Hello Toby,

Thanks for your reply. Would you be interested in sharing this code/application with others on this site? Maybe you could write and article? I for one would be interested...

Hello Everyone,

Just wanted to mention that this ability is available in SQL 2008 but does not work against older versions of SQL server. Also you have to create groups in...

Good question. Not sure if this can be done but I believe (not tested this) that you could. Best to try it on a test server first. Up to now...

Hello Glen,

Sounds like that I was going through when I first started this code. For example, I only wanted to know when a job failed so that I could review...

Thank you very much for all the kind words. I feel that I've been a DBA long enough (8 years) and that it's time to share with all the people...

Hello Everyone,

Hope you like the article and I am hoping to write more showing how to use the remote management to help do other tasks.

If you have any ideas...

There are 2 things that you need to check before executing the code in the article.

1) Enable DAC. This is DISABLED by default as per Microsoft.

2) Database should be...

Thanks to everyone for help me out here and for the nice comments about the article. In the new year I'll have more time and will try to update the...

Would you be willing to post an updated version of the complete code to correct the issues? As mentioned I don't have much time right now but will look at...

WOW! Love all the comments and code changes everyone is posting!

Now Mr Kehayias ask a good question

"If this is intended for SQL 2005/2008 why are you using legacy...

Are you executing the code on a SQL 2005? Does not work on SQL 2000.

Here is the link for more information on CROSS APPLY

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

Rudy

This works on SQL 2005/2008, x32bit and x64bit, stand alone or on a multi instance installation.

DAC is not available in SQL 2000 or earlier, but I wish it did.

Rudy