Home > Management Studio, SQL Agent, SQLServer, SQLServer 2005, SQLServer 2008, SQLServer 2008 R2, SQLServer 2012 > SQL Server – Reading ERRORLOG with xp_ReadErrorLog
  1. Bala Krishna
    January 25, 2013 at 9:41 pm

    Hi Vishal,

    This is really amazing stuff from you.

    Thanks for posting.

  2. Dhiva
    June 18, 2013 at 7:15 pm

    fantastic one

  3. Jason
    October 29, 2014 at 12:43 am

    What is the default for the SortOrder?

  4. $ubha
    April 14, 2015 at 11:52 pm

    I tried using the startdate and enddate parameters, but no luck,
    am i missing anything :

    exec sys.xp_readerrorlog 2,2,NULL,NULL,’20150414′,null

  5. rahul jain
    June 25, 2015 at 9:09 pm

    what if want to eliminate some log containing specific message ?

  1. February 8, 2013 at 12:42 pm
  2. February 8, 2013 at 12:46 pm
  3. May 1, 2013 at 10:48 am
  4. May 3, 2013 at 2:03 am
  5. August 21, 2013 at 4:06 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 319 other followers

%d bloggers like this: