Detect if SP is running 
Author Message
 Detect if SP is running
Is there a way to find out if another instance of a SP is already running or
are SP's always executed sequentially?

Thanks in advance



Sat, 22 May 2004 03:31:30 GMT
 Detect if SP is running

    You have to do it programmatically. In SQL2000, you can use the
application locks via "sp_getapplock" & "sp_releaseapplock" to do this. If
you are on SQL70, then you can use a global cursor to do this.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )



Sat, 22 May 2004 05:28:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How To detect that a sp is already running

2. Detect if SP is running

3. What SP am I running?

4. What SP am I running?

5. Run sp in anther sp in Selet

6. SP - Possible to run sp from ASP webpage?

7. A SP that run a list of SP

8. Error running SP as Job but not when run from Query Analyzer

9. run sp vs run code executes slower - makes no sense

10. Detecting FK violation in sp

11. What am I doing wrong with this SP??

12. Detecting what server name runned a SP


 
Powered by phpBB® Forum Software