capture start/end datetime, user name and stored procedure name

[mjhessler]

Need to capture start/end datetime, user name and stored procedure name for every time any non-system stored procedure runs for a specific DB on a server.

Also need to do the same for Crystal Reports not using stored procedures.

Can this be done without a purchase third party package such as Quest Performance Analysis or Idera Diagnostic Manager? Does anyone know how they do it?

Michael

 

[genomon]

Sorry can't help with your prob, but can give you a heads-up: posting your address/phone is a terms/conditions violation & could be a problem with Mr. Moderator.
Good luck on your quest!

I have great faith in fools; self-confidence my friends call it.
-Poe

 

[mrdenny]

You can do this with a trace.

You could setup a trace to start when the server is booted and have it capture all commands into a table for later use.

You would need to closly monitor the drive space and clear out the data to ensure that you don't run out of space.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com