Some sql server 2008 question

[E_Gold]

Hi how i can see if the server is working or not ? in sql server 2000 there was tool that show it if there Isn't any tool, how i can open and close the server ? (script ?...) thank's in advance

[Lost User]

E_Gold wrote:

how i can see if the server is working or not ?

Just try to open a connection :)

E_Gold wrote:

how i can open and close the server ?

Open the Control Panel, go to the Administrative Tools and open the "Services" applet. From there you can start and stop the service.

Wha?

[E_Gold]

is there any script that can open/close the server ? thank's

[Lost User]

No SQL script; if the server is closed, how would you execute that SQL-script? You can use VBScript[^] :)

I are Troll :)

[E_Gold]

I mean batch file

[Lost User]

net start [Service]

and

net stop [Service]

:)