I am usually using SQL server management studio to execute my stored procedures on a remote server. Unfortunately, I will have to start a few sprocs that will take a long time. However, I would prefer to shut down my office PC after I have started them. I am just wondering whether it is possible to start sprocs on the server without being logged in until they have finished. I guess I will have to use sqlcmd? Is this right?
Any pointers would be very much appreciated. Many thanks in advance.