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 database would affect the ability to use this DMF and that running it from a database at 80 compatibility would fail. It turns out the person was running...(read more)