How to get data when SqlException.Class < 16

  • Thread starter Thread starter Rudi
  • Start date Start date
R

Rudi

Hi,

I have a master proc that calls a different 'child' proc for a set of
records.
When a Raiserror occurs in the child proc, I 'handle' it in the master proc
and update a status field in the record to 'Error' and set the returned
error message.
When all records have been processed, I return the record id, the status and
the message for the set of records.

In query analyzer, I can see that this resultset is correctly returned, it
also prints the raiserror statements.

But in C# code, I always get the SqlExceptions for the 'child' proc. And no
way to get to the returned resultset. Is there a way to 'ignore' the
SqlExceptions and still get the returned resultset back?

Rudi
 
Back
Top