SQL Server compatibility mode not logged

Posted by smithsi on Server Fault See other posts from Server Fault or by smithsi
Published on 2010-03-02T15:24:02Z Indexed on 2010/04/08 23:03 UTC
Read the original article Hit count: 283

Filed under:
|
|

I've been researching a problem which was diagnosed as someone changing the compatability mode for the SQL Server database from 80 to 90 on SQL Server 2005 for a database which had it's compatibility mode set to 80 due to legacy stored procedure code not having been upgraded.

I found that when changing the compatibility mode this is not logged in the SQL Server logs.

Has anyone seen this issue and is this a bug or is there an alternative method to track these changes?

© Server Fault or respective owner

Related posts about sql

Related posts about server