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.

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

Is there a way to view the SQL Server errorlogs in Amazon's RDS? I usually use sp_ReadErrorlog, but in RDS we need to be a member of securityadmin role.

share|improve this question
    
The more I use SQL Server on RDS, the less I like it. So many features are missing. – datagod Jan 21 '13 at 21:41
up vote 1 down vote accepted

Per the documentation, there's a custom stored procedure that does just that:

EXEC rdsadmin.dbo.rds_read_error_log [index]
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.