Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How can i know which stored procedure is executed when and by which program? Expand / Collapse
Author
Message
Posted Monday, November 26, 2007 6:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 3, 2008 10:43 AM
Points: 3, Visits: 13
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
Post #425712
Posted Monday, November 26, 2007 6:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 10:01 AM
Points: 280, Visits: 287
Hi,

The only way I know of to find out this information is by running the profiler and monitoring the execution calls as they happen. Since you haven't done this and are trying to find out when/who executed the SP in retrospectively I can't really help you. I'm not sure about SS2005 but in 2000 there was no way to achieve this. sorry

Is someone after doing something they shouldn't have?


Post #425734
Posted Monday, November 26, 2007 8:20 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 7:53 AM
Points: 42,822, Visits: 35,952
Please don't double post. It splits answers and wastes time

Continue thread here please



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #425802
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse