Net send script
I want to be able to stop sql server service and restart it via a script. So far i have:Net stop "Sql Server (Instance)"which works however since i have two instances it comes back saying "would you also like to stop the second instance" i would like to say "yes" however im not sure how i could add this to the script to override this question or simply pass in a parameter to say "yes".Overall i want it to stop and then restart later.Does anyone have any clues?Thanks
August 6th, 2008 4:31pm

Try thisnet stop "Sql Server (instance)" <c:\yes.txt And file c:\yes.txt contains only "y" Something like this below yyyyyyyyyyyyyyyyyyyy(only one 'y' eventually will work)
Free Windows Admin Tool Kit Click here and download it now
August 6th, 2008 4:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics