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 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, 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