Monday, February 20, 2012

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
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...
>
|||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...
>

No comments:

Post a Comment