Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 MS-SQL Server Service Manager

Author  Topic 

ira
Starting Member

1 Post

Posted - 2005-05-20 : 07:18:24
I would like to know if there is any vb-script (or any ather kind of script) that can automatically starts and stops MS-SQL Server Service Manager on Windows XP computer?
When I say start and stop MS-SQL Server Service Manager I mean start & stop SQL Server and SQL Server Agent services with the help of a script.
I must add that I am refering to the MS-SQL Server 2000 Enterprise Edition with SP3
I would like an answer soon please.Thanks a lot!!!

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-05-20 : 08:03:15
The Service Manager is just a little system tray app.
To start the service :

NET START MSSQLSERVER
NET START SQLSERVERAGENT

You can do it in a batch file, or use the wscript.shell from a vb script.


Damian
Ita erat quando hic adveni.
Go to Top of Page
   

- Advertisement -