instance

What is the best way to detect if an instance is available? From DMO?
I mean, I'd like to set up a kind of alert that would notify me if an
instance is down. It seems to be possible only from the OS.
Thanks,
kob uki> What is the best way to detect if an instance is available? From DMO?
Yes, you can do it from DMO - check the article at
http://support.microsoft.com/?id=287737.
Additionally, you can check Gert Draper's articles at
http://www.sqldev.net/misc.htm.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org