How to return current status from a stored procedure to my Vb.Net program?

[SnehaAgrawal]

Hi,
See if someone could help me with the following...

I have a stored procedure which I call from my Asp/Vb prog.
In that stored proc. I have written Insert,Update and many operations.I want my SP to return the status i.e Insert successfull etc. so that I can show it in a progress bar(or Label).I dont want to print msgs using PRINT in SP.Bcoz it prints after the SP is fully executed...

Thanks

[ck9663]

Try doing a RETURN <value> on your SP. You may also execute your SP as a recordset from your ASP, then do a SELECT ..... RETURN on your SP. Your ASP will treat it as an ordinary recordset.

Good Luck!!!

~~ CK