April 23, 2012 at 6:22 am
Hi All,
I am trying to read my SQL Sever ERROR Logs in management studio but i am unnable to apply filter option, when i apply any date range in filter selection window (in error logs) it was showing blank window but i can see errors (without selecting fiter).
Now i am trying to get through following sp, sys.xp_readerrorlog.
My requirment is how can i get Error details of this month 16th and 17th.
and how can i pass date range details to this procedure.
April 23, 2012 at 7:50 am
Make sure your tick the SQL SERVER box at the root of all the log files; this will automatically select all the log files. Then run your filter.
Logged events are spread across several files!
:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply