all users | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

all users

Hi all, I amnew to this, need to find all database users on the server!! thanks Thanks!!
SP_HELPUSER & SP_HELPLOGINS will give you such information.
Refer to the books online too for more information on returning such information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
To build a query of all your users on the server you can use SELECT,
l.denylogin FROM sys.server_principals p LEFT JOIN sys.syslogins l ON ( = ) WHERE p.type IN ( ‘S’, ‘G’, ‘U’ ) Also look up Catalog Views in books online