I wanted to know if there are any automated methods/ways to check for SQL server instance alerts.
I guess, in SQL server 2008, central management servers can be used for this by implementing Policy Management.
I need to know how would I receive an alert (possibly email) when a SQL server 2000/2005 instance goes down.
any sort of help is highly appreciated!!!...
thanks a lot, Mandar Alawani INDIA