By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

Error History?

P: n/a
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
Apr 2 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Apr 2 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.