How can I track Stored Procedure Changes?

  • How can I track Stored Procedure Changes?If I want to check that which SQL user modified the SP on which date,is there any way I can do it?I am using SQL Server 2005.What the rights needed for this?

  • Please don't cross post. Post your question in only one forum.

  • 1. By maintaining the proper commenting in the SP itself.

    2. By Genrating script & versioning it after each changes

    3. BY mainting ddl trigger to check the SP audit.

    😀

  • You can use a source control like vss. In SQL 2005 vss can be integrated to SSMS.

    "Keep Trying"

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply