I'm cleaning up permissions on my SQL Server 2000, and I want to test that a particular account still has sysadmin priveldges. What non-destructive tasks can only sysadmins do that I can use to confirm this?
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
|
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. |
|||
|
|
