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.
up vote 2 down vote favorite

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?

share|improve this question

2 Answers

up vote 3 down vote

You could use that account to create another login , and grant it sysadmin privileges.

share|improve this answer
up vote 1 down vote

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.