Steve Jones - SSC Editor (8/24/2014)
Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).You don't want to do this in SQL Server. [font="Arial Black"]Use Windows at the service level to check if the service is running[/font], and if not, send an email that way.
How would one do such a thing?
As a bit of a side bar and a play on words, "Just because you can do something in SQL Server, doesn't mean you SHOULDN'T"! 😉
--Jeff Moden
Change is inevitable... Change for the better is not.