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 ful if SQL logged all errors it
generates, or if something like that can be set up.

Thanks,

Neil

Neil (nospam@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 ful 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, esquel@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