Home / server / Questions / 125261
Accepted
bdhar
Asked: 2010-03-23 22:07:10 +0800 CST

SQL Profiler Trace logs

  • 772

Suppose that I try to insert some data into a table and if the insertion fails due to some CDBException, will that be logged in to the SQL Profiler logs?

I am using SQL Server MSDE 2000

sql-server trace

2 Answers

  1. Best Answer

    SQL Profiler will log. depending on what events you have selected to log, the result of the operation. If this is the underlying cause of the exception then it will be logged.

    If the exception is due to a problem other than on the server (e.g. client has lost connectivity) then of course there is no error on the server to log.

    • 0

  2. You'll need to add events for BatchStarting, StmtStarting, RPCStarting to catch it most likely, but then you should see it.

    • 0