SQL Server 2005 and Database Diagrams!
So I’m creating a portal for my riding buddies so we can organise rides and communicate easily, and I’ve started getting back into App Dev with anger. The first hiccup has been with SQL Server 2005; specifically, the database diagram functionality in SQL Server SMS. Turns out, if you create a database with an owner that isn’t an SQL Server principal, or the database compatibility level is not 90, then you will get an error when trying to create diagrams.
The post above describes the issue, and my resolution was to reset the owner of my database to SA. Not sure if this is what will end up going into prod, as I’m not sure what the impact is, or why a DB Owner is required at all (with granular security being the primary determiner of db access).
Anyhoo, here I go again on my own…