2005: SIMPLE QUESTION: error log

Hello,
When I received a message "... See the SQL Server errorlog for details
..." I opened Management / SQL Server Logs where I see:
Current - 2006-05-30 12:19:00
Archive #1 - 2006-05-30 09:49:00
Archive #2 - 2006-05-30 08:27:00
etc.
But each of these logs contains "0 Item(s)". How to see log entries?
Thank you very much
/RAM/R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:
> Hello,
> When I received a message "... See the SQL Server errorlog for details
> ..." I opened Management / SQL Server Logs where I see:
> Current - 2006-05-30 12:19:00
> Archive #1 - 2006-05-30 09:49:00
> Archive #2 - 2006-05-30 08:27:00
> etc.
> But each of these logs contains "0 Item(s)". How to see log entries?

You did double-click on the error log in the list, did you?

You should be able to see log entries this way, but it could be some
permissions issue.

Also make sure that you have no filter active.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Tue, 30 May 2006 12:27:57 +0200, R.A.M. wrote:

>Hello,
>When I received a message "... See the SQL Server errorlog for details
>..." I opened Management / SQL Server Logs where I see:
> Current - 2006-05-30 12:19:00
> Archive #1 - 2006-05-30 09:49:00
> Archive #2 - 2006-05-30 08:27:00
>etc.
>But each of these logs contains "0 Item(s)". How to see log entries?
>Thank you very much
>/RAM/

Hi RAM,

Have you tried right-clicking the log and selecting "View SQL Server
Log"?

(Double-clicking the title works too)

--
Hugo Kornelis, SQL Server MVP