Ignore SQL Server 2000 store proc errors and still get results?

From: "Mike Jansen" <mjansen_nntp@xxxxxxxx>
Date: Wed, 10 Aug 2005 14:39:30 -0400

We have a SQL Server 2000 stored procedure that raises errors when run.
Because of what it is doing, this is expected. However, we have result sets
that are also being returned from the stored procedure.

Using either DataAdapter or SqlDataReader, we'd like to be able to execute
the stored proc and still get the result sets back. However, exceptions are
thrown whenever the stored proc raises an error. Is there any way to ignore
or suppress these errors and still get the result sets?

Thanks,
Mike

.

Follow-Ups:
- Re: Ignore SQL Server 2000 store proc errors and still get results?
  - From: Mary Chipman [MSFT]
- Re: Ignore SQL Server 2000 store proc errors and still get results?
  - From: Mike Jansen

Prev by Date: Re: Microsoft Application Blocks Data Modification
Next by Date: Re: Ignore SQL Server 2000 store proc errors and still get results?
Previous by thread: MS data provider for Oracle - SELECT COUNT(*)
Next by thread: Re: Ignore SQL Server 2000 store proc errors and still get results?
Index(es):
- Date
- Thread

Relevant Pages

Re: Update statement performance decreases in stored proc
... Have you had a look at the execution plan of the stored procedure? ... Here are the important parts of the stored proc: ... I found that this was casued by the UPDATE statement at the end ...
(microsoft.public.sqlserver.programming)
Re: RETURN_VALUES ??? done... What have I gained?
... b (aka whipper-snapper) ... > similar questions via stored proc and can set up a function to do the work ... >> tAdoDataSet is really easy to use. ... >> dataset even though you are pointing to a stored procedure. ...
(borland.public.delphi.database.ado)
Re: Use query or stored procedure
... >>OR write a stored procedure in SQL Server and pass the parameters to it? ... > should change, you can still keep your stored proc interface the same, ... your finished applicaiton to Access. ...
(borland.public.delphi.database.ado)
Re: RETURN_VALUES ??? done... What have I gained?
... Who is Doctor Codd? ... similar questions via stored proc and can set up a function to do the work ... > tAdoDataSet is really easy to use. ... > dataset even though you are pointing to a stored procedure. ...
(borland.public.delphi.database.ado)
TableAdapter, INNER JOINs, stored procs, and problems with Update
... I have a stored procedure that uses JOINs to return columns from multiple ... I also have another stored proc that that takes a series of params ... @ac2 int, ...
(microsoft.public.dotnet.framework.aspnet)