Share via

Find what I am looking for

David Rogers 1 Reputation point
2020-08-26T15:43:49.37+00:00

This was my query page url: 

 https://learn.microsoft.com/en-us/search/?terms=sp_enumerrorlogs

I got: "8,300 results for 'sp_enumerrorlogs'"

I searched 5 or 6 pages without encountering "sp_enumerrorlogs" in the article description.

Is there some other way to find what I am looking for? I tried "subject:sp_enumerrorlogs", "title:sp_enumerrorlogs", ...

Help!:-)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,871 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2020-08-26T19:46:41.09+00:00

    I am not sure what you are asking, but that is an undocumented proc used internally by SQL Server.

    I suggest you start here:
    https://www.mssqltips.com/sqlservertip/3135/search-multiple-sql-server-error-logs-at-the-same-time/

    0 comments
  2. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2020-08-27T06:07:07.843+00:00

    Hi @David Rogers ,

    The procedure returns the log (archive) number, date it was created, and the size.

    Please check if below links could help you. This only a blog mentioned this procedure.

    https://sqljana.wordpress.com/2018/04/20/sql-server-a-more-flexible-xp_readerrorlog-that-reads-all-error-logs-including-archives/

    Best regards,
    Cathy

    ===============================================

    If the response helped, do "Accept Answer" and upvote it.

    0 comments