Issue sql server query and restart windows service

• kapfundestanley

  SSCertifiable

  Points: 5637

  More actions

  March 23, 2014 at 11:52 pm

  #286904

  How can i best issue an sql query and also restart a windows service from a remote machine?

  “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

• MyDoggieJessie

  SSC-Forever

  Points: 44519

  More actions

  March 24, 2014 at 8:57 am

  #1699566

  Powershell?

  What query are you attempting to run? And are you asking to restart a windows service on an external machine via TSQL?

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• SQLBlimp

  SSCertifiable

  Points: 6340

  More actions

  March 24, 2014 at 10:48 am

  #1699612

  kapfundestanley (3/23/2014)

  ---

  How can i best issue an sql query and also restart a windows service from a remote machine?

  My first temptation is to issue a wiseacre answer like:

  1. SSMS

  2. Control Panel > Administrative Tools > Services > Connect to another computer

  But seriously...

  1. Are you trying to do both from a scripted situation, such as a scheduled task?

  2. If so have you considered a batch script running osql for the SQL and then a SC \\[machinename] STOP and SC\\[machinename] START

  Thanks

  John.

• kapfundestanley

  SSCertifiable

  Points: 5637

  More actions

  March 25, 2014 at 1:21 am

  #1699738

  Yes ,I have managed to do a batch script:

  sqlcmd -i C:\scripts\C2.sql

  sc \\servername stop Servicename

  sc \\servername start Servicename.

  This is working if I want to run script ,start and stop service on the same server.When the server to run script and start/stop service is different the batch script is not working.

  “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

• paul.knibbs

  SSCoach

  Points: 15320

  More actions

  March 26, 2014 at 3:33 am

  #1700183

  You need to tell SQLCMD which server to connect to in order to run the script you're passing it--you do that with the -S parameter (note that's a capital S, lowercase s does something else). You may also need to supply a username and password (using -U and -P) depending on the situation.