default database

I using the copy database wizard to copy databases from one server to
another. When I copy a db to the new server, it changes the default db
setting for all the users of that db to 'master'. Am I not running the
wizard correctly?
If this is how it works, how do I reset the setting to the db name I want?
I can do it manually but I have atleat 5 databases I have to copy and each
has a lot of users.
Look up sp_defaultdb in Books Online.
http://www.aspfaq.com/
(Reverse address to reply.)
"sql" <sql@.discussions.microsoft.com> wrote in message
news:F2413537-6302-4194-9D7E-4AEBCFBE28F4@.microsoft.com...
> I using the copy database wizard to copy databases from one server to
> another. When I copy a db to the new server, it changes the default db
> setting for all the users of that db to 'master'. Am I not running the
> wizard correctly?
> If this is how it works, how do I reset the setting to the db name I want?
> I can do it manually but I have atleat 5 databases I have to copy and each
> has a lot of users.
sql