Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif";}

Hello Experts,

We currently have a procedure that pulls data from other databaselink.  This procedure takes quite a long time (2 hours+) to process and dump the data into one table.   The user gets the browser timed out.  Here are my questions:

·         What happens to the current procedure processing if the browser timed out or closed?   Is it still running or it drops right after the browser closed?

·         Is there a way to know if the proc is still running?

·         If that process is running, is there a way we can kill it?  By command line?

Your guidance/help is truly appreciated. 

le9569

le9569:

·         What happens to the current procedure processing if the browser timed out or closed?   Is it still running or it drops right after the browser closed?

·         Is there a way to know if the proc is still running?

·         If that process is running, is there a way we can kill it?  By command line?

The answer to question 2 and 3 is that you monitor the activity by putting a trace on the database from Sql Server Management Studio and having located the process id, kill the process. Regarding question 1, the process might continue. You can get a more expert answer by asking at:

• SQL Server Team http://www.sqlteam.com/forums/
• SQL Server Central http://www.sqlservercentral.com/
• SQL Server at MSDN http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1