Track the Deleted Procedure

• SqlUser-529296

  SSCarpal Tunnel

  Points: 4072

  More actions

  August 19, 2008 at 12:34 am

  #189499

  Hi,

  Is it possible to track the deleted Stored Procedure in SQL Server 2005?

  ---

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  August 19, 2008 at 1:14 am

  #859808

  Could you explain a bit more what you mean with "the deleted stored procedure".

  Are you looking for info about who and when a stored procedure was deleted, then have a look at the default trace or the schema changes history report in SSMS.

  If it's something else you're looking for please give more info.

  [font="Verdana"]Markus Bohse[/font]