problems moving a database

[holdahl]

I have 2 databases (lets say db1 and db2).
I want to copy the data from db1 to db2, but the problem is that it seems like the roles are also copied. Because when I try to give a user dbo role, it says that the username already exists(or something like that). The user had dbo role on the original db.
The databases are not called the same.
How to you copy data from a database without getting things like roles and privileges? Is this possible?

sH

 

[BudTheGrey]

I would think you could do it by creating a text file of the table(s) using dbunload, edit the resulting reload.sql to use the new table name, then use Interactive SQl to create/load the table to the other database. Then assign rights as needed.