Invoke Batch file from Remote machine

  • Hello,

    I have created a batch file to restart one of the SQL Server service and I would like to invoke it from a remote machine.Is it possible??If yes,how?

    I really appreciate all of you for attempting to help me out.

  • There are several options you can use. It's preferred to execute the commands with a commandprompt utility like powershell. Examples can be found on the internet, just google a bit.

    You could also initiate a batchfile through a linked server using xp_cmdshell, but because you want to restart the SQL Engine the connection will be terminated and you will not know if the restart is succesfull.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply