Update to change permissions for running sp_readerrorlog and sp_enumerrorlogs in SQL Server


This cumulative update changes the permissions that are required in order to execute the sp_readerrorlog or sp_enumerrorlogs stored procedures in SQL Server 2012, 2014, or 2016. If you use either the SecurityAdmin server-level role or the View Server State permission, you can execute the sp_readerrorlog and sp_enumerrorlogs stored procedures.

Update information

This permissions change for the sp_readerrorlog and sp_enumerrorlogs stored procedures is included in the following cumulative update of SQL Server:

Cumulative Update 1 for SQL Server 2014 SP2

Cumulative Update 3for SQL Server 2012 Service Pack 3

Cumulative Update 1 for SQL Server 2016

Cumulative Update 8 for SQL Server 2014 SP1

Recommendation: Install the latest cumulative update for SQL Server


Microsoft has confirmed that this is a design change in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology that Microsoft uses to describe software updates.

Article ID: 3149128 - Last Review: Aug 25, 2016 - Revision: 1