Prev: How do you improve SQL performance over large amount of data?
Next: Using SQL Server (T-SQL) to parse text
From: arfanameer@hotmail.com on 2 Feb 2005 07:09
I want to retrieve the list of all logins in the sql server. can anyone
help me in that?

From: saghir.taj on 2 Feb 2005 08:59
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=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.

From: saghir.taj on 2 Feb 2005 09:02
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=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.

From: Mark D Powell on 2 Feb 2005 11:13
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 --

From: saghir.taj on 2 Feb 2005 17:51
check again!

www.dbnest.com

 | 
Pages: 1
Prev: How do you improve SQL performance over large amount of data?
Next: Using SQL Server (T-SQL) to parse text