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