List of Logins

[arfanameer]

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

[saghir.taj]

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

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

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

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

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]

check again!

www.dbnest.com