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

Stored Procedure Still Running


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.