I'm cleaning up permissions on my SQL Server 2000, and I want to verify that a particular account still has sysadmin privileges.
What non-destructive tasks can only sysadmins do that I can use to confirm this?
You could use that account to create another login , and grant it sysadmin privileges.
One way is to try executing something with xp_cmdshell such as ping. If you don't have this enabled you can enable it briefly for the test then disable it again.
You don't have to perform any task (destructive or non-destructive) at all.
You can use the built-in function
Note that for roles other than
You can use the built-in stored procedure
Or a complete list of all explicit members of all server roles:
For SQL Server 2000 there is also the option to sort or filter the result set using:
For SQL Server 2005+ there is already a system view to be queried directly: