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.

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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/