July 3, 2008 at 10:39 am
It often happens that if you have a repeating error or warning message the SQL errorlog becomes very large and you cannot view it to see what is going on. does anyone know of a windows utility that works like the unix tail command, where you can see just the last few lines of a file to see whats gong on?
---------------------------------------------------------------------
July 3, 2008 at 11:34 am
Outside of SQL, you can use a free app called Textpad. Inside of SQL you can use sp_readerrorlog ... then you could dump it into a temp table with an ID and pull back the last X records.
July 3, 2008 at 11:44 am
Microsoft has a log file reader that's currently free. It's on their web site. Allows you to query the files as if they were SQL tables. Check that out.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 9, 2008 at 9:28 am
thanks guys. I'll check both out. gsquared, any info on what to search for on the MS site?
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply