Click to See Complete Forum and Search --> : capturing SQL error


yan
05-26-2003, 01:35 AM
Hi all,
My store procedure return 0 if no error, raiserror and return 1 if it has problem. In ASP, how do I capture the return value and error message? Any one has a sample code? Thanks

yan
05-26-2003, 11:54 AM
what about the return statement? At the end of my store proc, I put return 0 indicating everything is okey. How do I capture that zero? Thanks