Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ws5926
Yak Posting Veteran
88 Posts |
 Posted - 2006-08-07 : 14:32:05
|
| I have stored procedure that I don't want 2 copies of it running at the same time. How do I check if the stored procedure is already running in another instance? I know that I could setup a table and just put a row in the table when it starts and empty it when I leave. I want to know if there is a check that I can do on some system table that will tell me the same info.Thanks in advance for any responses to this post. Live to ThrowThrow to Live |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-08-08 : 03:53:54
|
| You can query master..syscacheobjects table, if you have access to it.Since when you run SP it's plan gets cached, you will have a row for it in syscacheobjects table.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
How to check if stored procedure is running?