As of 2019-10, for SQL Server Management Studio, they did not upgrade it to add the create ER Diagram feature. I would suggest try using DBeaver: I am using both Mac and Windows and I was able to download the community edition. I logged into my SQL server database and was able to create the ER diagram using the DBeaver.

In our case, we restored a 2008 R2 Database in SQL 2016 and we had the same problem trying to use the diagram in any way. After running SSMS 2016 13.0.15900.1 as administrator it solved the problem. Go figure!

Nov 16, 2010 · To use Database Diagram Designer, it must first be set up by a member of the db_owner role to control access to diagrams. And. any user with access to a database can create a diagram. In other words, a user with db_owner permissions must first enable diagrams in the database (to create the sysdiagrams table) and then anyone can create them.

Jul 9, 2015 · Ownership of diagrams can only be transferred to members of the db_owner role. This is only possible if the previous owner of the diagram has been removed from the database. If the owner of a diagram has been removed from the database, the diagram will remain in the database until a member of the db_owner role attempts to open it.

Jun 14, 2012 · For better quality After generating the diagram in sql server management studio. Go to File -> page setup. Set print Scale into 10 or lower.

Sep 1, 2015 · I ran into this problem when SQL Server 2014 standard was installed on a server where SQL Server Express was also installed. I had opened SSMS from a desktop shortcut, not realizing right away that it was SSMS for SQL Server Express, not for 2014. SSMS for Express returned the error, but SQL Server 2014 did not.

May 23, 2017 · MS Visio has a function to generate a database diagram from an existing database. For Vision 2008 go to Tools->Add-Ons->Visio Extras->Database Wizard. I used it a few years ago, but have no sql server at hand to test it right now. EDIT: Just saw that you specifically asked for SQL Designer. Have a look at the manual. Basics. The application ...

Jul 19, 2016 · I have a very large database I need to diagram. The database is SQL Server 2008 on x64. It is large in that there are hundreds of related tables, each with up to 2000 fields (some are sparse), multiple relationships between tables (often hundreds per table, in fact), multiple schemas... you get the idea.

I'm using a Local MS SQL Database, the database was created automatically using entity framework. The database is created with out any errors. However when I use Microsoft Managment studio to try and create a database diagram I get the following error:

If SELECT @@SERVERNAME; is not accurate (it should say DevPC), then in order to ensure that your server rename has taken hold within SQL Server, you may also want to issue the following: EXEC sys.sp_dropserver @server = N'old server name'; GO EXEC sys.sp_addserver @server = N'DevPC', @local = N'local'; GO