 Report Abuse |
To know who and when index was created or deleted
4/28/2015 11:39:58 AM
Schema Change History report from either database or instance.
Right click on database name>>Report>>Standard Reports>> Schema Change History
Using the Default Trace in SQL Server 2005 and SQL Server 2008
for more details
http://www.mssqltips.com/sqlservertip/1739/using-the-default-trace-in-sql-server-2005-and-sql-server-2008/
|