Auditing SQL Server database configuration changes.
Is there a way to audit changes made to SQL Server configuration settings in SQL SERVER 2005?somehow, my production SQL SERVER database compatibility mode got change from 80 to 90. This caused couple of stored procedures with deprecated =*inner and outer *= join operators to choke.I would like to track down who made the changes and when the changes took place.Can someone point me in the right direction. please?
I can't remember whether or not this is an option with SQL Server 2005, but I know it works with 2008 or 2012. From Management Studio Object Explorer, right-click the database, and choose Reports/Standard Reports/Schema Changes History. Check the DDL operations performed at the database level.