Is Stored Procedure Running??

[talon121a]

Is there anything I could do to determine programatically
if a specific stored procedure is running?

Whats best practices with this?? Anyone know?

Jason

 

[talon121a]

Forgot to mention, Im running SQL Server 2000.

And writing the 'application' in ASP.

 

[lebisol]

hopefully your stored_proc is "executed" but NOT "running"
if it is runnung then it has locked up!
so u should be looking for error cature of the DB or confirmation that stored_proc was executed!....
I personally I am happy with just response.write()
On Error Resume Next
do it
If Err <> 0 Then
Response.Write &quot;Error encountered: &quot; & Err.Description
End If...


perhaps u can add an aditional DB file that will capture erros on a particual URL & action taken on your main DB(edit.update.del.insert); time stamp and user at the time of erros....
much like you talon I am willing to learn if anyone else has better solutions ( I don't know about .net and win2003 server if it has some new components that will do this for you)
All the best!

> need more info?
:: don't click HERE ::

 

[talon121a]

Maybe I didnt make it clear.

I was interested in a method to find out how 'via either asp or stored procedure...' to find out if a Stored procedure is currently running. (So that I dont execute the same procedure again)

-jason

 

[lebisol]

maybe:

http://www.sql-server-performance.com/ac_extended_stored_procedures.asp

> need more info?
:: don't click HERE ::

 

[talon121a]

Thanks for that url to common stored procedures,
with that url, reading it a bit, I guess something
I could do to determine if a stored procedure is currently
running or is not done yet is to write a registry entry
before the procedure runs and after the procedure runs. Then programatically check if the key exists.

Any other suggestions?

ty