Answered by:
SP_READERRORLOG

Question
-
Hi,
Can any one give me some references to study about sp_readerrrolog. I want to know why it is used and how it works.
Monday, December 29, 2014 1:25 PM
Answers
-
sp_readerrorlog uses xp_readerrorlog in the background. refer this blog http://sqlserver-help.com/2014/12/10/sql-internals-useful-parameters-for-xp_readerrorlog/
Balmukund Lakhani
Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter | Facebook
Author: SQL Server 2012 AlwaysOn - Paperback, Kindle- Proposed as answer by Shanky_621MVP Monday, December 29, 2014 1:48 PM
- Marked as answer by Phaneendra Kalapatapu Tuesday, December 30, 2014 4:16 AM
Monday, December 29, 2014 1:32 PM -
Hello ,
sp_readerrorlog is called an undocumented system stored procedure . It's allow to read the contents of the SQL Server error log files and allows to search for certain keywords when reading the error file.
For example :
EXEC sp_readerrorlog 6
Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/
- Edited by Ahsan KabirMVP Monday, December 29, 2014 4:41 PM
- Proposed as answer by Donghui Li Tuesday, December 30, 2014 3:19 AM
- Marked as answer by Phaneendra Kalapatapu Tuesday, December 30, 2014 4:16 AM
Monday, December 29, 2014 4:30 PM -
sp_readerrorlog basically gives you the latest errorlog. It is a wrapper stored procedure using the xp_readerrorlog extended stored procedure inside.
Check this article for more info
http://mssqlwiki.com/tag/sp_readerrorlog-parameters/
Regards, Ashwin Menon My Blog - http:\\sqllearnings.com
- Proposed as answer by Shanky_621MVP Monday, December 29, 2014 1:48 PM
- Marked as answer by Phaneendra Kalapatapu Tuesday, December 30, 2014 4:16 AM
Monday, December 29, 2014 1:33 PMAnswerer -
see
http://blog.sqltechie.com/2011/03/xpreaderrorlog-parameter-detail.html
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page- Proposed as answer by Shanky_621MVP Monday, December 29, 2014 1:49 PM
- Marked as answer by Phaneendra Kalapatapu Tuesday, December 30, 2014 4:16 AM
Monday, December 29, 2014 1:36 PMAnswerer
All replies
-
sp_readerrorlog uses xp_readerrorlog in the background. refer this blog http://sqlserver-help.com/2014/12/10/sql-internals-useful-parameters-for-xp_readerrorlog/
Balmukund Lakhani
Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter | Facebook
Author: SQL Server 2012 AlwaysOn - Paperback, Kindle- Proposed as answer by Shanky_621MVP Monday, December 29, 2014 1:48 PM
- Marked as answer by Phaneendra Kalapatapu Tuesday, December 30, 2014 4:16 AM
Monday, December 29, 2014 1:32 PM -
sp_readerrorlog basically gives you the latest errorlog. It is a wrapper stored procedure using the xp_readerrorlog extended stored procedure inside.
Check this article for more info
http://mssqlwiki.com/tag/sp_readerrorlog-parameters/
Regards, Ashwin Menon My Blog - http:\\sqllearnings.com
- Proposed as answer by Shanky_621MVP Monday, December 29, 2014 1:48 PM
- Marked as answer by Phaneendra Kalapatapu Tuesday, December 30, 2014 4:16 AM
Monday, December 29, 2014 1:33 PMAnswerer -
see
http://blog.sqltechie.com/2011/03/xpreaderrorlog-parameter-detail.html
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page- Proposed as answer by Shanky_621MVP Monday, December 29, 2014 1:49 PM
- Marked as answer by Phaneendra Kalapatapu Tuesday, December 30, 2014 4:16 AM
Monday, December 29, 2014 1:36 PMAnswerer -
Hello ,
sp_readerrorlog is called an undocumented system stored procedure . It's allow to read the contents of the SQL Server error log files and allows to search for certain keywords when reading the error file.
For example :
EXEC sp_readerrorlog 6
Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/
- Edited by Ahsan KabirMVP Monday, December 29, 2014 4:41 PM
- Proposed as answer by Donghui Li Tuesday, December 30, 2014 3:19 AM
- Marked as answer by Phaneendra Kalapatapu Tuesday, December 30, 2014 4:16 AM
Monday, December 29, 2014 4:30 PM