Log of stored procedures run on my SQL 2005 box.

9860 pts.
Tags:
SQL
SQL 2005
SQL Log Files
SQL Server 2005
SQL Server stored procedures
Stored Procedures
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following