Showing posts with label dbuser. Show all posts
Showing posts with label dbuser. Show all posts

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