As much as I want to share everything for free, unfortunately the domain and hosting used to host all these articles are not free. If you see ads appearing on this site and getting annoyed or disturb by them. This blog is my life-long term project, for me to share my experiences and knowledge to the world which hopefully can be fruitful to those who read them and in the end hoping to become my life-long (passive) income. Hi, thanks for reading my article. Since you are here and if you find this article is good and helping you in anyway, help me to spread the words by sharing this article to your family, friends, acquaintances so the benefits do not just stop at you, they will also get the same goodness and benefit from it. JILAXZONE – Jon’s Interesting Life & Amazing eXperience ZONE. Use AdventureWorks2017 EXEC sp_changedbowner ‘sa’ĭo you have anything you want me to cover on my next article? Write them down on the comment section down below.Īlternatively, find more interesting topics on JILAXZONE: FREE!
If the database is “AdventureWorks2017” and the login id used is “sa”, this is the command you need to run on SSMS. Run the following command to resolve the issue. You may encounter Error 15517 when creating Database Diagram – SQL Server
(Microsoft SQL Server, Error: 15517)”, typically the error is because the database owner isn’t the same as the user you are using to login to database. When restoring AdventureWorks database (or any other database) then tried creating Database Diagram, you may get this error, “Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. SQL Server Error: 15517, Principal “dbo” does not exist That’s it! You can redo step #3 to step #8 above on any database you have on SQL Server. If the auto-arrangement is not good enough for you, you can arrange yourself. Generate Latest AdventureWorks Database Diagram (works too for any databases)ġ) Ensure you have SQL Server up database and running, ensure too you have the SQL Server Management Studio (SSMS).Ģ) Ensure you have restored AdventureWorks database (refer here for detail steps).ģ) Open SSMS then open and expand the AdventureWorks database (or any other database you want to generate the database diagram).Ĭlick on Arrange Tables to arrange the Database Diagram tables – SQL ServerĨ) If needed to arrange the tables, do right click on the empty space, and choose “Arrange Tables”. And the good thing is that, this steps is regardless of which version of the AdventureWorks is and also can be used to generate database diagram for other databases as well.
#Adventureworks database diagram how to
Image above is showing the latest AdventureWorks2017 database diagram, however FYI, the database diagram shown above doesn’t have complete set of AdventureWorks tables – I just select what I needed.īut don’t worry, in case the diagram isn’t sufficient for your work, here I’ll show you how to generate the database diagram yourself. Training using the latest Microsoft SQL Server AdventureWorks database and need the latest database diagram?Īs of when this article is written, the latest AdventureWorks database is AdventureWorks2017, found here.
0 kommentar(er)
