March 31, 2009 at 2:20 pm
In SQL 7.0 and 2000 (8.0), a utility called scm.exe exists which can be used to start & stop services.
e.g. running next from a DOS command prompt stops the full-text service on current server:
scm -Action 6 -Service mssearch
This utility can be found in following folder after typical installation of SQL 2000:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
Where did it go in SQL 2005 (9.0) ?
What about SQL 2008 ?
Are there any other ways of stopping & starting existing services that are not user interactive?
Needs to be invoked from C++ 6.0, i.e. prior to .NET functions.
My code can call a program, and was hoping to use scm - but that does not exist everywhere.
Stopping full-text service via Management Studio is interactive, and will not solve my issue.
Thanks.
March 31, 2009 at 2:39 pm
net stop and net start?
---------------------------------------------------------------------
March 31, 2009 at 2:52 pm
Tried those, they work from DOS command prompt but not when sent via my program.
Seem to be more interactive than scm, e.g. display a message box with OK button.
Is `net` a program?
If so, where does it reside in SQL 2005?
Had to specify exact path to get scm.exe to work.
Also tried sp_start_job, but could not get that to recognize any service.
March 31, 2009 at 3:44 pm
net is an Os command like cd or dir. So will run from any directory location
have you tried putting the commands in a.bat file with replies to prompts and running that, e.g
net stop mssqlserver /y
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply