Transfer Logins

4 May 2006 3:50 PM

MBSNewbie

Hi All,
I'm trying to Add a DTS Package to Transfer Logins from My Production
Environment to My Test Environment. It keeps erroring out without a reason.
I'm thinking it's because users are logged into production. Is there a
way to get around this? (SQL 2000)
Thanks!

4 May 2006 7:55 PM

Keith Kratochvil

Why don't you just script them out and transfer them yourself?

HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

--
Keith Kratochvil

Show quote

"MBSNewbie" <tamki***@hotmail.com> wrote in message
news:%23I0$WK5bGHA.3856@TK2MSFTNGP03.phx.gbl...
> Hi All,
> I'm trying to Add a DTS Package to Transfer Logins from My Production
> Environment to My Test Environment. It keeps erroring out without a
> reason.
> I'm thinking it's because users are logged into production. Is there a
> way to get around this? (SQL 2000)
> Thanks!
>