Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sandy336
Starting Member
2 Posts |
 Posted - 2008-10-28 : 13:01:46
|
| Hello,I have installed Sql Server 2008 in my system, while installing it is asked me to select the users. I have given System as the user assuming that the current user/Admin is going to be the user and I haven't given any password in the password fields. I hope this would not be any problem.I got the database from my friend who is using sql server 2008, and when I attached the database it didn't import relationships, and moreover when I try to open the database diagram it is asking me to select the user from the database properties and files.Is it a problem with Sql Server installation or is there any supporting file missing for this functionality to be done.Thank you all |
|
|
sandy336
Starting Member
2 Posts |
Posted - 2008-11-03 : 11:50:59
|
| Atlast I found solution to my problem, it was the owner problem. In Sql Server 2008, if you detach your database with one owner and attached in other machine with other owner it will import relationships but it won't import Keys. So to get the Keys imported to your database, detach and attach the database with the same owner |
 |
|
|
|
|
|
Keys are not Imported when I Attach the database