Merill Fernando

Principal Product Manager @ Microsoft Entra

less than 1 minute read

I ran into a wierd error message when trying to view the Diagrams on a database that was migrated to SQL Server 2005. Something about the user not being valid and to change the database owner.

A quick search brought up this quick fix:

Try running this command to change the compatibility level to SQL Server 2005.

EXEC</font> sp_dbcmptlevel database_name, 90

Works like a charm! [SQL BOL]

Categories:

Updated:

You may also enjoy

Device filter > Device platform

less than 1 minute read

When designing a conditional access policy and have the choice between using device filter and device platform always use device filter.

What I use

less than 1 minute read

I’m frequently asked about the apps I use. So here’s a list for future reference so I can avoid repeating myself 😀