Log of stored procedures run on my SQL 2005 box.
How
can I tell who ran which stored procedure on our SQL 2005 server and at
what time? Can we see if one stored procedure called other stored
procedures there as well? Can we enable verbose logging somehow as well
for more data?
Software/Hardware used:
HP Server, SQL 2005, Windows 2008
Software/Hardware used:
HP Server, SQL 2005, Windows 2008
ASKED:
September 15, 2010 5:22 PM
UPDATED:
September 15, 2010 7:09 PM
Answer Wiki:
You can use SQL Profiler to capture this information. Monitor the Statement Stopped and Batch Stopped to see what commands where started and stopped.
If needed you can setup a server side trace to monitor every stored procedure which is run, but this will create a very large trace file very quickly, especially on a busy database server.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
