vrao19
asked on
How do I check if the SQL server(s) is running or not?
How do I check if the SQL server(s) is running or not? and notify through email if the sql server has stopped running..
Is there a monitoring tool that I can use?
thanks in advance
Is there a monitoring tool that I can use?
thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://sqlserver-training.com/sql-script-to-check-if-cubes-processes-are-running-or-not/-
with ASP.Net Application:
http://stackoverflow.com/questions/22979/detecting-if-sql-server-is-running
For Setting Email Alerts:
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/44eb704f-a0bb-4ceb-8470-60b2ddb0b3c6/