2/13/2011 · Parameters which would be useful when you run xp_readerrorlog or sp_readerrorlog. XP_READERRORLOG . Syntax: xp_readerrorlog-> Reads the current SQL Server errorlog. xp_readerrorlog 3 -> Reads SQL Server errorlog “errorlog.3” xp_readerrorlog-1, 2 -> Reads the current SQL Agent errorlog. xp_readerrorlog 3, 2 -> Reads the SQL Agent errorlog No 3 archive, 12/10/2012 · The name of the stored Procedure is sp_readerrorlog and it allows us to read the contents of the SQL Server Error log from the SSMS and we can also filter the result set as per our requirement. sp_readerrorlog takes four parameters: Error log file we want to read: 0 = current, 1 = Archive #1, 2 = Archive .
7/27/2015 · The script below uses the sp_readerrorlog undocumented store procedure. You can replace the two parameters with whatever search string you’re looking for. –Read error log stored procedure. –First Param: 0 = current, 1 = Archive #1, 2 = Archive #2, etc. –Second Param: 1 or NULL = error log, 2 = SQL Agent log.
8/13/2020 · SQL Server offers an undocumented system stored procedure sp_readerrorlog . This SP allows you to read the contents of the SQL Server error log files directly from a query window and also allows you to search for certain keywords when reading the error file. This is a sample of the stored procedure.
5/15/2013 · sp_readerrorlog or xp_readerrorlog is a very handy system stored procedure to get database error log details for SQL Server. Following is the simple syntax to use it: sp_readerrorlog. OR. Xp_readerrorlog. Note: The maximum length of the message is 255 chars wide, anything wider will be truncated.
SP_READERRORLOG parameters « MSSQLWIKI, How to Load SQL Server Error Log into Table for Analysis …
Reading SQL Server Error Logs | The Lone DBA, How to Read Log File in SQL Server using TSQL
