How can I maintain the keys and relationships when importing/exporting DBs in SQL server 2005? Everytime i do an import/export, the keys are lost and the relationships are gone.

I tried to use "Copy objects and data Between SQL Server databases" option, but it always fails while performing the copy. The error is always "...[sql server] 'mylogin' is not a valid login or you do not have permission"

[edited by: Raymond at 11:06 am (utc) on Nov. 15, 2006]