Prev: Deleting multiple columns from multiple objects
Next: SQL Assistance required
From: Neil on 2 Apr 2008 00:45
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


From: Erland Sommarskog on 2 Apr 2008 03:00
Neil (nospam(a)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(a)sommarskog.se

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
 | 
Pages: 1
Prev: Deleting multiple columns from multiple objects
Next: SQL Assistance required