March 27, 2008 at 8:59 am
I am looking for either an audit tool or some technique to audit changes to Stored Procedures, Triggers, Functions living in the database.
Is there any SQL Server utility out there that can help me do this?
Thanks
Shahab
March 27, 2008 at 9:03 am
Check out DDL triggers in BOL. This allows you to do exactly what you are looking for.
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
March 27, 2008 at 10:03 am
or the Schema Changes History report available in SSMS 🙂
Tommy
Follow @sqlscribeMarch 27, 2008 at 10:13 am
This is what I see in the report.... wonder why?
Schema Changes History: [tripwiredb]
on 006-sql2005 at 3/27/2008 12:11:11 PM
This report provides a history of all committed DDL statement executions within the Database recorded by the default trace.
Schema Change History
Shows changes made in the schema of the objects by DDL operations.
March 27, 2008 at 5:02 pm
This report will show you what changed, but it won't show you how it changed, like in an ALTER situation. The report actually derives from traces which you can find under C:\Program Files\Microsoft SQL Server\MSSQL.N\MSSQL\LOG, where N is the number of the directory corresponding to the database engine install.
As pointed out, DDL triggers can be used to track schema changes. Short of this, you'll need to develop your own trace if you want to keep an active log of every change. If you're just looking to do comparisons over time, you may want to look at tools by Red Gate or ApexSQL designed for this purpose.
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply