Thanks to Ninja for providing the code in a copy/paste format. Not sure why the article's code is showing up that way.

By the way, if you copy the complete article...

Thanks you for providing better code. I'm hoping that eventually we'll have a a nice stored procedure that you can execute when/if the SQL server gets into trouble.

Is there any...

Oh.. it must be new. I'll give it a look.

Thanks,

Rudy

Thanks for info. Unfortunately the Idera product does not work on Blackberry technology... the last time I looked.

Thanks for all your time and efforts!

Rudy

It work just fine when I select a SQL 200 server but when I select a SQL 2005 the error produced is show below.

Hopefully you or someone can figure this...

I have a SQL 2008 Dev server setup for any testing I want. If I could just get this app working with SQL 2005 then I would test it fully...

I've tried the SQL Web Administrator tool. It's only good for SQL 2000 and does not work with SQL 2005 and SQL 2008.

So I'm still looking for a tool.

Thanks everyone...

Anyone tried this with SQL 2005 or SQL 2008? I have and it doesn't work as SQL 2005+ does not use SQLDMO.

Thanks for the info. I'll download and try this tool.

Rudy

Yes I understand the possible issues with this configuration. If you have assigned the right roles/rights to the right users this should not be an issue.

My reason for setting...

Does anyone know how you would get SQL server to receive your email and execute the query? I'm looking around for examples and am having not luck.

But the way, thanks...

Are you executing this on a SQL server with more than one instance? I've tried on SQL server 64bit as I don't have any 32 bit servers.

Hello,

Nice script. I've tested it a SQL server with 6 instances and your code does not product the instance name. It seem to work on default instance only.

I like...

Nice worrk! Do you have a version that works with SQL 2005?

Rudy