July 1, 2010 at 1:28 am
Hi Experts,
This is just out of curiosity...How can i stop sql server service from query window??
I tried net stop mssqlserver in SQLCMD mode and i go the response
The following services are dependent on the SQL Server (MSSQLSERVER) service.
Stopping the SQL Server (MSSQLSERVER) service will also stop these services.
No valid response was provided.
SQL Server Agent (MSSQLSERVER)
Do you want to continue this operation? (Y/N) [N]:
July 1, 2010 at 1:34 am
Have you tried stopping SQL Agent first? It should prevent that prompt from showing.
-- Gianluca Sartori
July 1, 2010 at 1:35 am
SHUTDOWN WITH NOWAIT
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply