Return Status from SQL Server - Executing Stored Procedure

[jtrapat1]

I'm using VB6 against SQL Server and I need some help.
From a drop-down menu in my VB app, I'd like to execute a stored procedure (an update which passes some
parameters)
on SQL Server.

I'd like the sp to execute in the background and then pass a return code on completion or failure of
the sp to the VB program;
Possibly display a message box to the user or some popup to let them know that the job completed.

Can anyone suggest the best way to do this?
I know sql server comes with a bunch of built-in sps; but the one closest to what I need is only suitable
for OLE Automation.

Thanks in advance.

John