Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Where database diagrams reside in SSMS?

April 26, 2017database diagrams ssms

0

Posted

Where database diagrams reside in SSMS?

1 Answer

0

Posted

Before discussing features of SQL Server database diagrams it would be better to clarify a couple of messages that you may face while working with SQL Server database diagrams. Confirmation message while starting with database diagrams in SSMS The first time you click on the Database Diagrams folder of any user database in SSMS, you may get the following dialog. It is not an error, but just a permission seeking dialog to create some system stored procedures that are necessary to work with database diagrams. If you choose No then no procedures will be created and you will not be able to work with SQL Server database diagrams. If you choose Yes then the following system stored procedures would be created in your database and you will be able to work with SQL Server database diagrams.