How to track from which hostname the Store Procedure was changed

• dakshinamurthy-655138

  SSCertifiable

  Points: 5172

  More actions

  December 4, 2008 at 10:59 pm

  #128995

  Hi,

  Using SQL Server 2005, i need to find from which hostname the Store Procedure was changed as we have many Store Procedures, and is getting updated often, i just want to know how to keep track from which hostname which Store procedure was changed or altered.

  Dakshin

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 5, 2008 at 5:38 am

  #908185

  Check out this thread: http://www.sqlservercentral.com/Forums/Topic613439-146-1.aspx. You can also use a DDL trigger, see BOL for how.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question