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

I just launched 🦋 Bluesky.ms!

1 minute read

🚀 I just launched my weekend hack project 🦋. With Twitter becoming unusable a whole heap of the Microsoft community is now on Bluesky and having a blast.