Master database Compatibility level after an In-place Upgrade
- by Jonathan Kehayias
Yesterday a forums member asked why sys.dm_exec_sql_text() wouldn’t work on one instance of SQL where he was a sysadmin while the same code worked correctly on another instance of SQL. The initial thought was that it was some kind of permissions issue. Ken Simmons ( blog / twitter ) pointed out that the compatibility level of the…