How can i know which stored procedure is executed when and by which program? [modified]
-
I want to know which stored procedures are executed in the last 24 hour in my database and i wish if i could also know about the program who called the stored procedure? OR I can know about a specific stored procedure that when it was executed last time and by which program? Please help...its urgent? Regards, Zeeshan Malik -- modified at 12:21 Monday 26th November, 2007
To do what can be done is a Intelligent Job and to do what should be done is a Genious Job done is a Genious Job
-
I want to know which stored procedures are executed in the last 24 hour in my database and i wish if i could also know about the program who called the stored procedure? OR I can know about a specific stored procedure that when it was executed last time and by which program? Please help...its urgent? Regards, Zeeshan Malik -- modified at 12:21 Monday 26th November, 2007
To do what can be done is a Intelligent Job and to do what should be done is a Genious Job done is a Genious Job
You need to look at using SQL Profiler to identify what's going on down at the database level. It won't tell you exactly which program calls the SQL, but it will tell you what SQL is hitting the database and who is doing it? Take a look at this[^] article for details. Now a request - please don't put it's urgent in a post. They are all urgent to somebody, and this doesn't help anybody.
Deja View - the feeling that you've seen this post before.