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

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 at 21:41

1 Answer

up vote 1 down vote

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.