Search

Wednesday, February 27, 2013

How to check status of SQL services using TSQL

EXEC xp_servicecontrol N'querystate',N'MSSQLServer'

EXEC xp_servicecontrol N'querystate',N'SQLServerAGENT'


No comments:

Post a Comment