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 |
|
noamg
Posting Yak Master
215 Posts |
 Posted - 2004-06-09 : 11:36:28
|
| hi,is it possible to lock a store-procedure ?how ?Noam Graizer |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-09 : 11:44:59
|
| With a remote or key?What do you mean by lock?Brett8-) |
 |
|
|
noamg
Posting Yak Master
215 Posts |
Posted - 2004-06-09 : 11:47:46
|
| I have many application that call to the same store-proc.I want only one app can run it at the same timeNoam Graizer |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-09 : 12:25:21
|
| Sounds like a poorly designed sproc...Why what's it doing that it can only be executed in a serial manner?Sharing permanent work tables?I might put a switch table that has only one row (using a trigger to make sure) then have the sproc update the switch to 1 when someone calls it and back to 0 when it exits.Also have the sproc check the switch, if it's 1, exit with an "in use" message.But still this is a bad designMOOBrett8-) |
|
|
|
|
|
|
locking a process