May 9, 2003 #1 bbitzer Programmer Joined Feb 4, 2003 Messages 8 Location US Is there a way to tell if a stored procedure is running so the same proc is not executed again at the same time from another user?
Is there a way to tell if a stored procedure is running so the same proc is not executed again at the same time from another user?
May 9, 2003 #2 bassguy Programmer Joined Jun 21, 2001 Messages 336 Location US Hi, just a suggestion, have you tried locking the data the proc calls then the second proc call will just wait in a queue bassguy Upvote 0 Downvote
Hi, just a suggestion, have you tried locking the data the proc calls then the second proc call will just wait in a queue bassguy
May 9, 2003 #3 cheyney Programmer Joined Jul 16, 2002 Messages 335 Location CA You could also put the stored procedure in a job. You can't re-execute a job while its running. Cheyney Upvote 0 Downvote
You could also put the stored procedure in a job. You can't re-execute a job while its running. Cheyney