**login problem**

Hi
I am working with SQL 2000 and I have a resotred database with these users
in branch of its users :
DB1
user login
-- --
dbo X
L1L1
L2L2
but in other databases I have the following list:
DB2
user login
-- --
dbo sa
XX
L1L1
L2L2
I always create login names and user names with the same name, so in
related databases they will appear like above and a row of (dbo,sa) which
is default in each database.now I want to change the list of my first
database in order to be similar like the second list. how does it
possible? in other word,how can I have the row of (dbo,X) in 2 rows of
(dbo,sa) , (X,X)?
Thank you in advance.
Hi
Lookup sp_changedbowner stored procedure in the BOL
<R> wrote in message news:ops47g3iu4mw7tkz@.system109.parskhazar.net...
> Hi
> I am working with SQL 2000 and I have a resotred database with these users
> in branch of its users :
> DB1
> user login
> -- --
> dbo X
> L1 L1
> L2 L2
> but in other databases I have the following list:
> DB2
> user login
> -- --
> dbo sa
> X X
> L1 L1
> L2 L2
> I always create login names and user names with the same name, so in
> related databases they will appear like above and a row of (dbo,sa) which
> is default in each database.now I want to change the list of my first
> database in order to be similar like the second list. how does it
> possible? in other word,how can I have the row of (dbo,X) in 2 rows of
> (dbo,sa) , (X,X)?
> Thank you in advance.
|||Uri's answer was correct but you may find these useful for stuff along those
lines:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scri...tions/1598.asp Script
Roles and Permissions
Andrew J. Kelly SQL MVP
<R> wrote in message news:ops47g3iu4mw7tkz@.system109.parskhazar.net...
> Hi
> I am working with SQL 2000 and I have a resotred database with these users
> in branch of its users :
> DB1
> user login
> -- --
> dbo X
> L1 L1
> L2 L2
> but in other databases I have the following list:
> DB2
> user login
> -- --
> dbo sa
> X X
> L1 L1
> L2 L2
> I always create login names and user names with the same name, so in
> related databases they will appear like above and a row of (dbo,sa) which
> is default in each database.now I want to change the list of my first
> database in order to be similar like the second list. how does it
> possible? in other word,how can I have the row of (dbo,X) in 2 rows of
> (dbo,sa) , (X,X)?
> Thank you in advance.