1) allow modifying Stored Procedures through only source control, not allowing changing/running scripts within SSMS directly. When necessary, Not allowing viewing stored procedures in text format. 2) If you have previledge, create a trigger over DDL, then log the change along the new scripts. thus you can compare two version when needed. 3) .........
【在 s**m 的大作中提到】 : 1) allow modifying Stored Procedures through only source control, not : allowing changing/running scripts within SSMS directly. When necessary, Not : allowing viewing stored procedures in text format. : 2) If you have previledge, create a trigger over DDL, then log the change : along the new scripts. thus you can compare two version when needed. : 3) .........
p*l
5 楼
Create a DDL After trigger to log it. It is very easy. There is one in the sample database - AdventureWorks.