Stored Procedure question

• Jerry Tienters

  Newbie

  Points: 1

  More actions

  January 15, 2004 at 9:33 am

  #358919

  Sqlserver 2000 sp 3 ---

   

  How do I determine the last time a stored procedure was executed ?

   

  Thanks.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  January 15, 2004 at 9:53 am

  #490241

  You can run profiler to trace it.

  Or create a history table and insert a record each time your sp is executed.

   

   

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738693

  More actions

  January 15, 2004 at 10:02 am

  #490246

  Allen's suggestions are the only way. There really is no other method and SQL does not track this.