How I can transfer login and password between SQL7 and SQL2000 Ser

Hi Good Day to everyone
In SQL7 Server have created some users ID with the passwords. I would like
to know how I can transfer those login IDs and Passwords into the SQL2000
server without re-create.
Besides, I would like to how to change the db ownership after I transfer the
ID and password?
Please advise.
Polar Bear.
* Polar Bear is new to SQL DB
Here are some articles you may be interested in:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
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://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
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
Andrew J. Kelly SQL MVP
"Polar Bear" <PolarBear@.discussions.microsoft.com> wrote in message
news:D76B2259-BEA3-4239-9BBB-2E24A2395DBC@.microsoft.com...
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer
> the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB
|||Check out http://www.support.microsoft.com/?id=246133 for transferring
logins.
With regards changing the database ownership, check out SQL Books On
Line for the sproc sp_changedbowner.
Regards
ALI
Polar Bear wrote:
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB