The Code
SQL Database Diagrams are invaluable in understanding the schema. I use them all of the time. Occasionally, I create the database tables and relationships from the diagram designer – try it – it’s great!
Of course, you cannot use database diagrams unless you have things set up correctly. At some point, diagrams stopped working on my databases. I don’t really understand why. However, the fix is simple: –
ALTER AUTHORIZATION ON DATABASE::[DATABASENAMEHERE] TO sa;
