Re: Lis of all logins?



Thanks Hari. I appreciate it.

Take care.

:)

"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:urcuKsS2GHA.1256@xxxxxxxxxxxxxxxxxxxxxxx
Execute the below command.

sp_helplogins

Thanks
Hari
SQL Server MVP

"J" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:OhoVuZS2GHA.4312@xxxxxxxxxxxxxxxxxxxxxxx
Hello. Does anyone know if there is a way to get a list of all of the
security logins for SQL Server 2000? I need to get a list of all our db
user names on our sql server and was wondering if there was a system
stored procedure in the master db or so that can do this.

Thanks in advance.

J





.



Relevant Pages

  • Re: Renumbering MS db ID?
    ... I'm not an Access user, but as far as the notion that 'there is no need to ... MS Access or MS SQL Server? ... There is no need to care what the ... > guarrantees that and it is the only purpose autonumber is used for. ...
    (microsoft.public.data.ado)
  • Re: Renumbering MS db ID?
    ... I'm not an Access user, but as far as the notion that 'there is no need to ... MS Access or MS SQL Server? ... There is no need to care what the ... > guarrantees that and it is the only purpose autonumber is used for. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Renumbering MS db ID?
    ... I'm not an Access user, but as far as the notion that 'there is no need to ... MS Access or MS SQL Server? ... There is no need to care what the ... > guarrantees that and it is the only purpose autonumber is used for. ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Server CE vs. DataTable
    ... The notification you want is part of Windows Mobile 5.0, ... honestly, if you really care about saving your data, I'd recommend writing ... >> If you truly don't care if you lose the data if your app ends or the ... I'm simply getting some data from a SQL Server ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: bugs with IF, SKIPROW, or ISNULL?
    ... >interesting, I'll try that, I figured the if statement would take care of ... if condition met then skiprow else okay.. ... the DTS engine uses to decide what it does next. ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)