I use the backup and restore facilities to move between multiple machines (like when I am working mainly on my desktop with a seperate SQL Server and need to copy to my laptop to take to a client or something). This avoids issues like you experience.

Right click on the database in question (in Enterprise Manager), select All Tasks, Backup. Backup type should be Database Complete, Add a device, select a file to backup to. Off you go. Copy that file to someplace accessible to the destination server. Create the database on the destination. Select it, right click, All Tasks, Restore. Select the file, go to the Options page and select the Force Restore over Existing Database option. Off you go, you will get a complete copy of the old database on the new server, complete and reay to roll.

Randy

>We've got our new SQL server up and running and I'm trying to copy our
>database from the old server to the new server.
>
>I detached the database from the old server, copied the data and log files and attached it to the new one. I can see it and navigate it just fine through enterprise manager but I cannot log into it through sa. It says that owner 'dbo' is not a user for this database. However, when I try to add the owner to the database it says it already exists.
>
>Are there any steps I'm missing for moving a database from one server to another?
>
>Jake