How to write a query to view OS and db authenticated users ...

Hi,

we have a sqlserver 2000 db with a mixture of OS and NT authentication.How to write a query (or get info) on users.


The query should be able to tell me that these users are OS authentiacted and these users are db authenticated.


Thanks,
-copernicus

sp_helpuser

Hi Mak,

Thanks for your reply I was wondering if there is a system table that I can query.


thanks,
-copernicus

select * from master.dbo.syslogins
select * from sysusers on all databases for seeing users

Or sp_helplogins, avoid to query system tables directly.