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 Administration (2000)
 check MS Sql server is running

Author  Topic 

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-09-06 : 12:01:59
How to check whether MS sql server is running or not from the command prompt?

Pls help.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-06 : 12:09:45
you can use osql:
http://technet.microsoft.com/en-us/library/aa214012(SQL.80).aspx

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-06 : 14:50:54
or net services i think...and there's a pretty neat command to check the status as well...

--------------------
keeping it simple...
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-06 : 23:08:10
Run 'net start' in dos prompt, it'll list all running services.
Go to Top of Page
   

- Advertisement -