Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rudy Panigas SQL Server Service Check Utility RE: SQL Server Service Check Utility

  • November 15, 2010 at 7:23 am

    #1250726

    For SQL 2008, the following will return a "specified service does not exist as an installed service" error:

    EXEC master.dbo.xp_servicecontrol N'QUERYSTATE',N'MsDtsServer'

    I changed the service name to MsDtsServer100 and it returned "Running.":

    EXEC master.dbo.xp_servicecontrol N'QUERYSTATE',N'MsDtsServer100'