DTS job to copy

I created a DTS package to copy a database from one server to another. I wan
t to change the collation of the existing database to insenseitive. During t
he set up of the DTS package I didn't check off collation , so I assume my d
estination database will ov
erride the source. I had an error after and and the process finished.
[microsoft][odbc sql serverdriver][sql server]user or role "user
_name"already exists in the current database.
what happened, and how can I correct it.I would guess you either already had a user in the database or you have
two users in the source database which only differ in case and are
considered the same user in the destination.
Either don't copy users or get rid of the duplicates
try in the source
select upper(name)
from sysusers
group by upper(name)
having count(*) > 1
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!