List of Logins

[arfanameer@hotmail.com]

I want to retrieve the list of all logins in the sql server. can anyone
help me in that?

[saghir.taj@gmail.com]

Re: List of Logins

Dear Arfan Ameer

Please see help for sysusers and syslogin in online books, sysusers and
syslogin are the tables which help you to get the requisite LIST.

e.g.
user master;
select * from syslogins ;
or
select * from master..syslogi ns ;

Umm you can make an inner join of syslogins with sysusers to get user
name for that particular login and can do lot of tricks :)

Download Microsot SQL Server 2000 System Table Map from

http://www.dbnest.com/index.php?page=documents&doc=2&dlcat=1

which may help u to understand the system table thing.

:) :) :)
Saghir Taj
MCDBA
www.dbnest.com: The Nest of DB Professionals.

[saghir.taj@gmail.com]

Re: List of Logins

Dear Arfan Ameer

Please see help for sysusers and syslogin in online books, sysusers and
syslogin are the tables which help you to get the requisite LIST.

e.g.
user master;
select * from syslogins ;
or
select * from master..syslogi ns ;

Umm you can make an inner join of syslogins with sysusers to get user
name for that particular login and can do lot of tricks :)

Download Microsot SQL Server 2000 System Table Map from

http://www.dbnest.com/index.php?page=documents&doc=2&dlcat=1

which may help u to understand the system table thing.

:) :) :)
Saghir Taj
MCDBA
www.dbnest.com: The Nest of DB Professionals.

[Mark D Powell]

Re: List of Logins

When I followed the link and selected download I got a page not found
error (404). It would appear something has moved or is unavailable.
-- Mark D Powell --

[saghir.taj@gmail.com]

Re: List of Logins

check again!

https://www.dbnest.com