Skip to Content
0
Former Member
Apr 29, 2013 at 04:32 PM

Stored Procedure Still Running

97 Views

I'm using 11.5 and Sql Server 2008.

I have developed a stored procedure that calls another subprocedure and inserts rows into a table.

This procedure runs about 5 minutes.

In the client window I have declared this procedure and then exec procname

The problem is the powerscript code waits about 2 minutes and then just goes to the next line of code not actually waiting for the proc to finish. So its actually still running on the server and seems to hang the client

I'm not using a return value or anything but when I used stored procedures for long running reports this never happens.

I'm on SQL Server and there is no command timeout option and it does not support async=1

Any help appreciated.

Richard