Start/Stop server via command line!!!

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Klaas-Jan SSCrazy Points: 2297 More actions · Answer 1

Hi,

use net stop mssqlserver

Edited by - Klaas-Jan on 07/15/2002 07:41:28 AM

Antares686 SSC Guru Points: 125444 More actions · Answer 2

To stop

NET STOP MSSQLSERVER

or if you are also running sql agent (It will ask if you want to stop related services the /y answer that without user input)

NET STOP MSSQLSERVER /y

To start

NET START MSSQLSERVER

or if you are also running sql agent (because agent requires SQL Server to be able to run SQL will be started automatically first).

NET START SQLSERVERAGENT

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

phusion SSC Journeyman Points: 98 More actions · Answer 3

Thanks. Another thing I was wondering how to do was to check to see if SP2 is installed.

Clive Strong SSChampion Points: 11222 More actions · Answer 4

Hey,

With regards to the installed SP...Is this SQL2000? If so, run the following command.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

For SQL 7, check the following link (too lazy to type it all - this contains the SQL2000 info too!)

Clive Strong

Antares686 SSC Guru Points: 125444 More actions · Answer 5

Here is a good list of the values from SELECT @@version to tell yuo th SP level.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)