Copy users between databases

21 Apr 2006 3:35 PM

Terry

Hello All,

I used DTS to copy one database to a blank database for a backup of the
database. A duplicate database.

How do I copy over the user logins to the new database.
This did not happen with DTS.

The databases are on the same instance of SQL.

Any help appreciated.
Thanks,
Terry
tgwill***@cox.net

22 Apr 2006 4:16 PM

Andrew Watt [MVP]

Terry,

Can you clarify if you are using SQL Server 2000 only or both SQL
Server 2000 and 2005? I wasn't clear after reading your question.

Thanks

Andrew Watt [MVP]

Show quote

On Fri, 21 Apr 2006 10:35:41 -0500, "Terry" <tgwill***@cox.net> wrote:

>Hello All,
>
>I used DTS to copy one database to a blank database for a backup of the
>database. A duplicate database.
>
>How do I copy over the user logins to the new database.
>This did not happen with DTS.
>
>The databases are on the same instance of SQL.
>
>Any help appreciated.
>Thanks,
>Terry
>tgwill***@cox.net