<div>
Thanks. That works fine.<br />
<br />
C
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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? <br />
<br />
Any pointers would be very much appreciated. Many thanks in advance. <br />
<br />
Chris
</div>
</div>


Hi,

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. 

Chris

starting time consuming sproc

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.