MS SQL Server - Script to list Users with SA Role on the server

Author

Script to list Users with SA Role on the server

shub

2006-01-18, 8:23 pm

I am wanting to get a list of all the users on a SERVER who has the
System Administrator role assigned to their login. I was wondering if
there is a script or table(s) that I could refer to instead of looking
at all the individual login names. We are using SQL Server 2000.

Any help on this regard will be greatly appreciated.
Thanks

P. Ward

2006-01-18, 8:23 pm

You can use the Stored Procedure sp_helpsrvrolemember
to view the members of
a fixed server role.

ie.

EXEC sp_helpsrvrolemember
'sysadmin'

- Peter Ward
WARDY IT Solutions

"shub" wrote:

> I am wanting to get a list of all the users on a SERVER who has the
> System Administrator role assigned to their login. I was wondering if
> there is a script or table(s) that I could refer to instead of looking
> at all the individual login names. We are using SQL Server 2000.
>
> Any help on this regard will be greatly appreciated.
> Thanks
>
>

Sponsored Links