Error History?

[Neil]

Is there a place where SQL Server logs errors? When I run my Access MDB
against a SQL 7 back end, I get ODBC errors, which are sometimes a little
descriptive, sometimes not at all. I usually have to execute code directly
against the back end to find out what's really going on. And that's if I'm
able to reproduce the error. It would be helpful if SQL logged all errors it
generates, or if something like that can be set up.

Thanks,

Neil

[Erland Sommarskog]

Neil (no****@nospam.net) writes:

Is there a place where SQL Server logs errors? When I run my Access MDB
against a SQL 7 back end, I get ODBC errors, which are sometimes a
little descriptive, sometimes not at all. I usually have to execute code
directly against the back end to find out what's really going on. And
that's if I'm able to reproduce the error. It would be helpful if SQL
logged all errors it generates, or if something like that can be set up.

C:\MSSQL7\LOG\ERRRORLOG

But plain users errors like PK violation, permission errors etc are not
logged there, only severe errors.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx