recovering logins

what is the best way to recover logins.
Let's say I need to rebuild a server or if my server crashes and I need to
reinstall sql server. What can I do so that I have a file or something that
saved my logins so that I can get them back on the server?
I'm used to sybase where you can just bcp the syslogins table.
Search KB for sp_help_revlogins. It will generate a script for you where the script includes
sp_addlogins and sp_grantlogin for your logins. The SQL Server logins will be created using the
original SID and passwords.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Cinderella" <Cinderella@.discussions.microsoft.com> wrote in message
news:F0314D8C-305E-4B2A-AAA6-01B9DCAD12BA@.microsoft.com...
> what is the best way to recover logins.
> Let's say I need to rebuild a server or if my server crashes and I need to
> reinstall sql server. What can I do so that I have a file or something that
> saved my logins so that I can get them back on the server?
> I'm used to sybase where you can just bcp the syslogins table.
|||sorry but what is KB?
"Tibor Karaszi" wrote:

> Search KB for sp_help_revlogins. It will generate a script for you where the script includes
> sp_addlogins and sp_grantlogin for your logins. The SQL Server logins will be created using the
> original SID and passwords.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Cinderella" <Cinderella@.discussions.microsoft.com> wrote in message
> news:F0314D8C-305E-4B2A-AAA6-01B9DCAD12BA@.microsoft.com...
>
>
|||I'm sorry I wasn't thinking - you mean knowledge base articles right?
Ok will do.
Are there any other ways or is this the only way?
"Cinderella" wrote:
[vbcol=seagreen]
> sorry but what is KB?
> "Tibor Karaszi" wrote:
|||> Are there any other ways or is this the only way?
Why do you want other ways to do this? This is the supported way, and it work just as fine as other
potential ways. The thing is that if you start doing some export of sysxlogins or similar, you are
into unsupported territory, without any benefits...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Cinderella" <Cinderella@.discussions.microsoft.com> wrote in message
news:AA91D7F2-B3E8-4D5F-A690-B037DAD935B5@.microsoft.com...[vbcol=seagreen]
> I'm sorry I wasn't thinking - you mean knowledge base articles right?
> Ok will do.
> Are there any other ways or is this the only way?
> "Cinderella" wrote:
the[vbcol=seagreen]