Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have read, e.g from here

that SecurityAdmin role can read Error logs. I'm on SecurityAdmin role and when I try to execute xp_readerrorlog I get a following error:

Msg 229, Level 14, State 5, Procedure xp_readerrorlog, Line 1
The EXECUTE permission was denied on the object 'xp_readerrorlog', database 'mssqlsystemresource', schema 'sys'.

What I'm missing? Can this role read error logs or not?

share|improve this question
up vote 1 down vote accepted

SecurityAdmin role can call sp_readerrorlog but not xp_readerrorlog because the role does not allow for using extended stored procedures. No big deal, just have three fewer parameter filters.

share|improve this answer
Ok, thanks very much! – atricapilla Jun 17 '10 at 5:08

Your Answer


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.