Manish Sinha
Ten Centuries
Points: 1023
More actions
July 24, 2008 at 5:47 pm
#381889
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?
Steve Jones - SSC Editor
SSC Guru
Points: 736162
July 24, 2008 at 10:39 pm
#848194
Please don't cross post. Post your question in only one forum.
abmore
Hall of Fame
Points: 3628
July 25, 2008 at 2:33 am
#848253
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.
😀
ChiragNS
One Orange Chip
Points: 26137
July 25, 2008 at 2:44 am
#848256
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