How to copy a database using Enterprise Manager
 = information
() = example text
Enterprise Manager > [find your database] > right-click [on your database] > All Tasks > Export Data > Next > Next >
Server: [the destination server (mssql.myserver.com) >
[select radio button] Use SQL Server Authentication >
Username: [the username for the destination database (dbm.mydb.com)] >
Password: [the password for the destination database (mypassword)] >
Next > Select "Copy objects and data between SQL Server databases" > Next >
Deselect "Use default options"
Click "Options" button
Deselect "Copy database users and database roles"
Deselect "Copy object-level permissions"
OK > Next > Next > Finish