Hi Guys.
I have 2 databases on my sql server, each database has different set of
users.
I want to copy the data between database "a" to database "b".
When i backup "a" and restore into "b" the database users also copy from "a"
and come to "b"
I want to replace these users, but i cannot delete them. because the
database user owns objects in database.
is there a way to rename the database users, or replace them?
Thanks in advance.This is a good page to help your problem
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"MAQ" <pakmaq@.hotmail.com> wrote in message
news:uwyiJVscDHA.1204@.TK2MSFTNGP12.phx.gbl...
> Hi Guys.
> I have 2 databases on my sql server, each database has different set of
> users.
> I want to copy the data between database "a" to database "b".
> When i backup "a" and restore into "b" the database users also copy from
"a"
> and come to "b"
> I want to replace these users, but i cannot delete them. because the
> database user owns objects in database.
> is there a way to rename the database users, or replace them?
> Thanks in advance.
>