Showing posts with label service status check. Show all posts
Showing posts with label service status check. Show all posts

Saturday, December 12, 2009

How to check SQL Services status from management studio?

You can use the below commands to check the sql services status from manangement studio.

xp_servicecontrol querystate, MSSQLAgent
xp_servicecontrol querystate, MSSQLServer
xp_servicecontrol querystate, msdtc