Moving logins

Hi
How can I copy or move the users from one SQL server to another?
Is there a utility that transfer them or should I create one by one?
Than'x
SHayGoogle on sp_help_revlogin. It does exactly what you want (assuming you mean logins and not users).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"S" <s@.s.com> wrote in message news:eh2Rqc4ZHHA.4008@.TK2MSFTNGP05.phx.gbl...
> Hi
> How can I copy or move the users from one SQL server to another?
> Is there a utility that transfer them or should I create one by one?
> Than'x
> SHay
>|||This holds good for SQL 2000. I could not find one for SQL 2005. Thanks.
"Tibor Karaszi" wrote:
> Google on sp_help_revlogin. It does exactly what you want (assuming you mean logins and not users).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "S" <s@.s.com> wrote in message news:eh2Rqc4ZHHA.4008@.TK2MSFTNGP05.phx.gbl...
> > Hi
> >
> > How can I copy or move the users from one SQL server to another?
> > Is there a utility that transfer them or should I create one by one?
> >
> > Than'x
> > SHay
> >
> >
>|||Here's an article that covers 2005:
http://support.microsoft.com/kb/246133
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Chinna Kondaveeti" <ChinnaKondaveeti@.discussions.microsoft.com> wrote in message
news:B5A02027-1873-4E6D-956A-F1DAC98332A3@.microsoft.com...
> This holds good for SQL 2000. I could not find one for SQL 2005. Thanks.
> "Tibor Karaszi" wrote:
>> Google on sp_help_revlogin. It does exactly what you want (assuming you mean logins and not
>> users).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "S" <s@.s.com> wrote in message news:eh2Rqc4ZHHA.4008@.TK2MSFTNGP05.phx.gbl...
>> > Hi
>> >
>> > How can I copy or move the users from one SQL server to another?
>> > Is there a utility that transfer them or should I create one by one?
>> >
>> > Than'x
>> > SHay
>> >
>> >|||Wonderful! I was looking for this for a long time. Thank you very much!
"Tibor Karaszi" wrote:
> Here's an article that covers 2005:
> http://support.microsoft.com/kb/246133
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Chinna Kondaveeti" <ChinnaKondaveeti@.discussions.microsoft.com> wrote in message
> news:B5A02027-1873-4E6D-956A-F1DAC98332A3@.microsoft.com...
> > This holds good for SQL 2000. I could not find one for SQL 2005. Thanks.
> >
> > "Tibor Karaszi" wrote:
> >
> >> Google on sp_help_revlogin. It does exactly what you want (assuming you mean logins and not
> >> users).
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "S" <s@.s.com> wrote in message news:eh2Rqc4ZHHA.4008@.TK2MSFTNGP05.phx.gbl...
> >> > Hi
> >> >
> >> > How can I copy or move the users from one SQL server to another?
> >> > Is there a utility that transfer them or should I create one by one?
> >> >
> >> > Than'x
> >> > SHay
> >> >
> >> >
> >>
>