Monday, February 20, 2012

Lis of all logins?

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.
JExecute the below command.
sp_helplogins
Thanks
Hari
SQL Server MVP
"J" <IDontLikeSpam@.Nowhere.com> wrote in message
news:OhoVuZS2GHA.4312@.TK2MSFTNGP02.phx.gbl...
> 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
>|||Thanks Hari. I appreciate it.
Take care.

"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:urcuKsS2GHA.1256@.TK2MSFTNGP02.phx.gbl...
> Execute the below command.
> sp_helplogins
> Thanks
> Hari
> SQL Server MVP
> "J" <IDontLikeSpam@.Nowhere.com> wrote in message
> news:OhoVuZS2GHA.4312@.TK2MSFTNGP02.phx.gbl...
>

No comments:

Post a Comment