Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Script to stop SQL server services and SQL instances.

 
   Database Forums (Home) -> Server RSS
Next:  Encrypting Data  
Author Message
user102

External


Since: Oct 14, 2003
Posts: 27



(Msg. 1) Posted: Fri Sep 07, 2007 10:11 am
Post subject: Script to stop SQL server services and SQL instances.
Archived from groups: microsoft>public>sqlserver>server (more info?)

What is the best way to write a scrip to Stop SQL Server service or SQL
Instance servies.
Thanks for the help.

 >> Stay informed about: Script to stop SQL server services and SQL instances. 
Back to top
Login to vote
Jay

External


Since: Aug 26, 2007
Posts: 42



(Msg. 2) Posted: Sat Sep 08, 2007 11:35 am
Post subject: Re: Script to stop SQL server services and SQL instances. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

net stop mssqlserver

<msnews.microsoft.com> wrote in message

> What is the best way to write a scrip to Stop SQL Server service or SQL
> Instance servies.
> Thanks for the help.
>

 >> Stay informed about: Script to stop SQL server services and SQL instances. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
why the MS DTC always stop services automatically ? - why the MS DTC always stop services automatically ? hi , two sql server MS DTC services stop services automatically : one server : After my anti-virus software killed a vbs virus , MS DTC services stop services automatically in a minute, then..

Is it really needed to STOP SQL Service before reboot the .. - Is it really needed to STOP SQL Service before reboot the server? Based on the the value in the registry key HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout, the server can kill the process if it takes too long to stop. I think it's not...

Transact SQL and selecting SQL Server instances - Is there anyway to specify what SQL Server instance you want to connect to from inside of a SQL Server Transact-SQL script? We have a SQL Server machine that is running two instances of SQL Server. Both instances have hundreds of tables to which we wan...

Make SQL Server Agent job stop after X minutes - I swear there is a way in SQL 2000 to have a SQL Server Agent job (that runs a DTS) to stop running if it's been running for X minutes. I can't find it though. I thought it was just a checkbox and a field for a number somewhere. any ideas?

Accessing one db by two sql server instances (eg. native v.. - Hi there As many people do nowadays, I have 2 XP installations on my laptop - one running natively and one in vmware box running on ubuntu (situation even more common with osx on intelmacs). Since I would like to be able to work on same development..
   Database Forums (Home) -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]