Stored Procedure that deletes and informs of success?

Hello all.

I have a SP (MS SQL 2000) that will delete select records from 3 unique
tables. The SP works fine but is there a way to return some kind of value
from the SP to know whether it worked or not?   I'm using ASP.NET to call
the SP but I need to know whether or not the SP was successful or not.  Make
sense?  Thanks!

Use an output parameter that returns what values you need.

--
Andrew J. Kelly  SQL MVP


"D. Shane Fowlkes" <shanefowlkes@h-o-t-m-a-i-l.com> wrote in message
news:eKtJ1rPVGHA.5496@TK2MSFTNGP11.phx.gbl...
> Hello all.
>
> I have a SP (MS SQL 2000) that will delete select records from 3 unique
> tables. The SP works fine but is there a way to return some kind of value
> from the SP to know whether it worked or not?   I'm using ASP.NET to call
> the SP but I need to know whether or not the SP was successful or not.
> Make sense?  Thanks!
>
>