Viewing 3 posts - 1 through 3 (of 3 total)
Also, the registry keys are different:
Had to change:
SET @REGKEY = 'System\CurrentControlSet\Services\MsDtsServer'
to
SET @REGKEY = 'System\CurrentControlSet\Services\MsDtsServer100'
November 15, 2010 at 8:16 am
No, 2005 and 2008 are different.
Here's a listing of the service names:http://blogs.technet.com/b/fort_sql/archive/2010/05/31/list-of-sql-server-service-names.aspx
Great script, by the way.
November 15, 2010 at 7:42 am
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...
November 15, 2010 at 7:23 am
Viewing 3 posts - 1 through 3 (of 3 total)