asked
Sql 2008 database changes
Does anyone know of any free software that i can install or a way to do so in sql. That will show me changes made to the database. Like delete procedures or altering them?
This site runs off of votes. Please mark all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that answer.
If free is your main requirement then run the Schema Changes History report in SSMS accessible through the right click menu in Object Explorer. It only shows changes since the last reboot, and it won't show the detailed breakdown of code changes, just that an object was changed and it resets on server restart... If you want anything more detailed, then store your code in a source control system, forbid ad-hoc changes to the database and script a periodic compare - that would be free.
You can define DDL trigger to track the stored procedure changes. It is simply code based out of the box solution and does not cost you anything. Refer to this post:
http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes on creating DDL triggers for create_procedure, alter_procedure, drop_procedure
You can use extended events to capture T-SQL statements on the system. That would be one way to know when there have been changes to the objects.
17 People are following this question.
