How to implement an Entity Relationship Diagram into a working database?
I need to implement a ER diagram into a working database. I’m hoping to use Microsoft SQL Server 2005 Developer edition. I need to know all the details of how to implement an ER diagram such as what happens to a relationships between entities, how to implement “Is a” relationhips, how to implement has a [...]

Answer Question   |  April 3, 2009  12:52 AM
ER diagrams, SQL Server 2005, SQL Server database diagram

database ownership won’t accept login
I’m trying to assign an owner to AdventureworksDW so I may turn on database diagrams. Neither the GUI interface nor the ‘Alter Authorization …’ method work. The sript approach reports success but whe reopened, the dialog still shows the property blank. Any ideas?

Answer Question   |  October 21, 2008  5:51 PM
AdventureWorksDW, Authorization, SQL Server 2005, SQL Server database diagram, SQL Server database ownership