Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted March 2, 2017

Who Changed My Database Schema?

By Greg Larsen

Have you ever wanted to know who made a schema change to your database?  If so, that information is tracked in the default trace.  The default trace is just a server-side profiler trace that gets started when SQL Server starts up, provided the default trace is enabled.  If the default trace is enabled, then it is extremely simple to report single database, or instance wide schema changes, using SQL Server Management Studio. 

To show the schema changes for a specific database, right click on your database and then when the menu is displayed hover over the “Reports” item.  When the next menu is displayed, hover over the “Standard Report” option.  On the “Standard Report” menu, you will see a “Schema Change History” menu option, as in the screenshot below:

Schema Change History
Schema Change History

When you click on the “Schema Change History” report then all the schema changes that are contained in the default trace, for your database, will be displayed.  Here is a sample of a schema change report for my DEMO database:

Schema Change Report
Schema Change Report

In the screenshot above you can see I created and altered a table named “MyNewTable”.

If you want to show all the schema changes for all the databases on your instance then right click on the instance name and select “Reports”, “Standard Reports” and then “Schema Changes”.  When you do this, all schema changes for any database on your instance will be reported.

See all articles by Greg Larsen



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM