Any additional steps to help resolve it?ĭoes this also apply to the Query Designer? I have a user with a background in Access that does all of his queries in the designer out of habit. Interestingly I can open and modify EXISTING database diagrams without any problems - I just get errors if I try to create a NEW diagram. I've experienced this at multiple sites on multiple workstations (SQL 2019). All replies text/html 5:07:44 AM CHEEKATLAPRADEEP-MSFT 0. Is that option removed from SQL Management Studio alal. I am using SSMS v18.6 and this "Index was outside the bounds of the array" error still occurs when I try to create a New Database Diagram :-(. I am not able to find create database diagram (ER diagram- refer the below screen shot) option in SQL Management Studio 2018 Preview. It is quite unbelievable that Microsoft would even consider deprecating such a valuable & useful feature in SSMS - astounding! Still exists in 18.7.1 if anyone's wondering, i can open any diagramas and edit them but i can't make new ones. Run SSMS as administrator and the database diagram will work. And then click OK.Īs Bill Edgbert wrote, running it as Administrator fixed the issue, but seems a mistake by Microsoft on listing tables with user DB rights.Īlso works when running SSMS as administrator as pointed out Bill Edgbert Right click on the database, and select Properties. In order to create SQL Database Diagrams, you must use "SA" as owner of the database. The whole premise of this article is incorrect. This error comes up if you are not using "sa".įor instance, I was getting this error even with my domain admin account which was also in the sysadmin role in SQL Server.Īfter connecting using "sa" things worked just fine in the very latest version of SSMS. There is no indication this is a deprecated feature.
CREATE ER DIAGRAM MYSQL MANAGEMENT STUDIO UPGRADE
Thus, if we are using SSMS 17 thru 18.0, we can just upgrade to 18.1 and newer versions and have this feature available again."Ĭan you really do it in SSMS 18.0, for example? "Fortunately, despite expectations, the "Database Diagrams" feature is available with SSMS 18.1 and later. Restart the sql server is one of the solutions for this problem. Hopefully this resolution will help someone else. Evidently the user interface gets confused. I was still experiencing this problem in 18.10. In SSMS, we locate "Databaseĭiagrams" just under the database, right-click on it and chooseĬlose the sql server is one of the solutions for this problem.
We will illustrate this process step-by-step, but before that let’sįor instance, assume we need to create a databaseĭiagram for our sample TestDB database. Thus, if we are using SSMSġ7 thru 18.0, we can just upgrade to 18.1 and newer versions and have this feature To use newer versions of SSMS with the "Database Diagram"įortunately, despite expectations, the "Database Diagrams"įeature is available with SSMS 18.1 and later. Older versions of SSMS will also solve the problem. It is easier to have this feature integrated into SSMS. To use many third-party tools to create database diagrams, we probably all agree that This feature, however, is very useful for many developersĪnd administrators and its absence can be quite uncomfortable. In spite of having the "Database Diagram" option underĮach database, it was actually removed and Microsoft considered itĪs a depreciated feature. Index was outside the bounds of the array.
0 kommentar(er)
