find-sql-server-log-errors.txt

--             Parameters:
--             int - log file number 0 is current, any other the nth file descending
--             int - 1 for SQL Server logs, 2 for Agent logs
--             string - search word 1
--             string - search word 2
--             date - from
--             date - to
--             desc - for descending, otherwise ascending as default

-- search server log for key word 'error'
xp_readerrorlog 0,1, 'Error', NULL, NULL, NULL,N'desc'