Moving or Copying Login information

[NewSQLUser]

Hi everyone,

I'm a very new user of SQL Server and looking for help in very simple terms. I will be testing with a production copy of the database. I am thinking about using DTS to move over the tables and objects. Is there a easier or more efficient way? I want to keep our production image so detaching the database would not be an option right? Once I move the tables and objects over how do I perserve the login, login password, and syncing them up so I can have an exact copy of our production database. I know most of you don't have a lot of time to explain things but I really need the help and step by step instructions if time permits would be greatly appreciated. We are using Sql Server 7.0

 

[tlbroadbent]

Check the following for step by step instructions.
[ignore]
HOW TO: Move Databases Between Computers that are Running SQL Server (Q314546)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546

INF: Moving SQL Server 7.0 Databases to a New Server with BACKUP and RESTORE (Q304692)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304692

INF: How To Transfer Logins and Passwords Between SQL Servers (Q246133)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133

INF: How To Transfer Logins and Passwords Between SQL Servers (Q246133)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133

[/ignore]

Fixing broken logins and transferring passwords

http://www.swynk.com/friends/boyle/fixingbrokenlogins.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.