Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RudiLarno
Starting Member
1 Post |
 Posted - 2005-07-01 : 10:09:11
|
| Hi,I have a master proc that calls a different 'child' proc for a set ofrecords.When a Raiserror occurs in the child proc, I 'handle' it in the master procand update a status field in the record to 'Error' and set the returnederror message.When all records have been processed, I return the record id, the status andthe message for the set of records.In query analyzer, I can see that this resultset is correctly returned, italso prints the raiserror statements.But in C# code, I always get the SqlExceptions for the 'child' proc. And noway to get to the returned resultset. Is there a way to 'ignore' theSqlExceptions and still get the returned resultset back?Rudi |
|
|
|
|
|
How to get data with SqlException severity < 16