Some of the most obvious things are often overlooked!
During one of my discussions with a client, I was asked for a simple way to detect all schema changes (DDL Operations) in the SQL Server database and to generate a report out of it. These people were interested in only the DDL operation performed and who performed it. To detect changes, they were planning to create a trigger, detect changes and then write it to a log file.
I advised them to use the Database Standard Reports which does the job for us
Open SSMS 2008 > Right Click a Database > Report > Standard Reports > Schema Changes History
The report displays you a history of all committed DDL statement executions within the Database
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|