>I know that I can use SQL Enterprise Manager to view each user's information individually, but is there a SQL built-in stored procedure or something that would aid administrator to manage login accounts and access information for all users within a SQL server in the form of report or something?
>
>Or is there a third-party utility that anyone knows of that would perform the above task?
>
>Thanks in advance for your help.
>
>CARIE
I'd suggest looking into SQL-DMO for what you want to do. SQL-DMO is an component object model that exposes administrative functions. There are collections for logins and users.
-Mike