Friday, March 30, 2012

Moving Users

How can I export users from one SQL 2000 server and
recreate them on another, maintaining the same
permissions they have on he first server without having
to do it manually?
Thanks
EmmaEmma,
Create a DTS Package using the Transfer Logins Task object.
Norman|||http://support.microsoft.com/defaul...kb;en-us;246133
Ray Higdon MCSE, MCDBA, CCNA
--
"Emma" <eeemoe@.hotmail.com> wrote in message
news:92fe01c3ea6c$f7ae51f0$a001280a@.phx.gbl...
quote:

> How can I export users from one SQL 2000 server and
> recreate them on another, maintaining the same
> permissions they have on he first server without having
> to do it manually?
> Thanks
> Emma

No comments:

Post a Comment