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 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:
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.