View Complete Post
I've look around the forums but I can't get the solution for my problem. I've installed Visual studio 2010 with sqlexpress edition. Then I have renamed my
computer. After renaming my computer I've deleted the directory
C:\Users\uporabnik\AppData\Local\Microsoft\Microsoft SQL Server
Data\SQLEXPRESS. After restart, I have started VS2010, open Server explorer and I've added the connection to a new database. I've been able to add new tabels, bu when I've tried to add a diagram, it didn't work. In properties window od the database I
saw, the the database owner was oldComputerName\username not newComputerName\userName. In
sql server management studio I've reanmed the user oldComputerName\userName to newComputerName\userName. After attaching the database it worked fine.
I've returned to Visual studio 2010. When creating new database, the owner of new database is oldComputerName\userName. The next tip was renaming the SQLServerMSSQLUser$ComputerName$SQLEXPRESS(and other names with sql...) in
Local Users and gorups in Mange My computer. After restarting the compter I've got the same result. When creating new .mdf file in server explorer of visual studio, the database owner is oldComputerName\userName.<
I am using SQL Server 2008. I have created a database containing ~50 tables and associated keys (primary and foreign) using T-SQL. I then added all the tables to a new database diagram using SQL Server's SMS. Is there any way to have SMS
automatically add/show all the relationships among all the tables?
Thanks in advance for any help in this matter.