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.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2002-06-30 : 04:34:04
|
| I want to stop a sql 2k server, i am doing the follwoing steps..1>pause the sql server2>net send all the coonected users ....saying server will be shut down in few mins....Is there any easier way? If users are connected then i can not stop sql server. Is there any way to forcefully stop the server? (without shutting down the o/s ofcourse...)Thanks in advance... |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-06-30 : 09:38:26
|
| I'm not sure why you are not able to stop SQL Server when users are connected. How are you stopping it and are you getting any error messages?Anyways, look up the SHUTDOWN command in SQL Server Books Online.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-07-01 : 13:38:43
|
| You can also KILL the spids one at a time if you need to. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2002-07-02 : 11:26:10
|
| Thank you very much.I was trying from Enterprise manager...right click and stop....shutdown and kill both works fine...Any idea why i got the error from EM? |
|
|
|
|
|
|
disconnecting users