copy users on server to another - SQL 2005 SP2

#1

I've built a development server for my SQL 2005 production
environment. I've restore the databases from a backup, and I want to
copy the users from my production to development machine.
How can I do this?
TIA
Rob

#2

One way is to use Transfer Login Task through SSIS
Thanks
Shiju Samuel

On Aug 27, 9:20 pm, rcamarda <robert.a.cama... (AT) gmail (DOT) com> wrote:

Quote:

I've built a development server for my SQL 2005 production
environment. I've restore the databases from a backup, and I want to
copy the users from my production to development machine.
How can I do this?
TIA
Rob

#3

On Aug 27, 1:35 pm, Shiju Samuel <shiju.sam... (AT) gmail (DOT) com> wrote:

Quote:

One way is to use Transfer Login Task through SSIS
Thanks
Shiju Samuel

On Aug 27, 9:20 pm, rcamarda <robert.a.cama... (AT) gmail (DOT) com> wrote:

I've built a development server for my SQL 2005 production
environment. I've restore the databases from a backup, and I want to
copy the users from my production to development machine.
How can I do this?
TIA
Rob

thanks! that did the trick!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

copy users on server to another - SQL 2005 SP2

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

copy users on server to another - SQL 2005 SP2 - 08-27-2007 , 11:20 AM

Re: copy users on server to another - SQL 2005 SP2 - 08-27-2007 , 12:35 PM

Re: copy users on server to another - SQL 2005 SP2 - 08-27-2007 , 01:30 PM