Re: 2005: SIMPLE QUESTION: error log



R.A.M. (r_ahimsa_m@xxxxxxxxxxxxxx) 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@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.



Relevant Pages

  • Re: SP4 Installation Problem on Win2000/SQL Enterprise Edit.
    ... Jasper Smith (SQL Server MVP) ... Check your network documentation. ... >> your install location). ... I can't find any log entries. ...
    (microsoft.public.sqlserver.setup)
  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: STORED PROCEDURE - passing table name as a parameter
    ... T-SQL, is that you get problems if the view definition does not fit into ... will need to query other system tables, for instance syscolumns. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Problem when changing Views
    ... There aree several reasons. ... I use neither of the tools, but I guess that Design View resubmits the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)