By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

List of Logins

P: n/a
I want to retrieve the list of all logins in the sql server. can anyone
help me in that?

Jul 23 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.

Jul 23 '05 #2

P: n/a
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.

Jul 23 '05 #3

P: n/a
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 --

Jul 23 '05 #4

P: n/a
check again!

www.dbnest.com

Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.