14 August,2013 by Jack Vamvas
Question: How can I find out who made a SQL Server database name change? A SQL Agent job failed this morning – and on closer inspection I discovered the database name was changed.
Answer: A quick way to discover details on a database name change is to inspect the SQL Server default trace.
The database name change is recorded in the SQL Server default trace as event Object:Altered. Follow this link for a query to grab the name change. SQL Server - Who made DDL table changes on the database.
If the database name change is a persistent problem, create a SQL Server Agent job which reviews the trace regularly and notifies you of any changes