EXEC sp_readerrorlog 1;

Hi,

EXEC sp_readerrorlog 1; usually gives me errors from days ago without the errors from today. When I look at the error logs in the Enterprise Manager, the first errors I see are indeed the ones appearing in my list which I retrieved from the sp_readerrorlog 1; but when I scroll down to the bottom, I can see the logs from today.

So, why is it that the logs from today do not appear in my list pulled from sp_readerrorlog 1; ?

I have this problem on multiple SQL Servers 2000 Enterprise Edition

I hope I'm not the only one with this problem.

Many thanks!

Regards,

Worf

First, be aware that sp_readerrorlog resides in the 'undocumented realm', so it's on use at your own risk policy.

sp_readerrorlog 1 says to read logfile #1, which is the file previous to the currently logfile.
(the default file# is 0)

File 1 may contain items from today (if recently cycled), yesterday or weeks or months ago, depending on how long the current log (file 0) has been active and not cycled.

Are you sure that you're really asking for what you think you're asking for, since you say you want 'the newest archived log'? I'd guess that it's most likely that sp_readerrorlog 1 won't show any logs from the current day in most cases.

/Kenneth

sql