Re: recovering logins

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Cinderella (Cinderella_at_discussions.microsoft.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 14:55:03 -0700

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:

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