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

• Michael Hessler

  Old Hand

  Points: 302

  More actions

  October 20, 2006 at 7:40 am

  #117218

  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 Hessler

  SQL DBA Consultant

  ASM International

  9639 Kinsman Road

  Materials Park, OH  ostalCode w:st="on">44073ostalCode>

  440-338-5151 ext. 5234

  michael.hessler@asminternational.org

   

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  October 20, 2006 at 9:06 am

  #667092

  For sql server you would use the SQL Profiler Tool

  it is fairly robust in terms of capturing events on the server.

  Heres a quick read

  http://www.developer.com/db/article.php/3482216