I'm running a stored-proc from VB. Why does it return control before the SP has finished?

A. Either because the SP is returning multiple resultsets or it has been invoked asynchronously.

Put "set nocount on" at the start of the SP to stop counts of rows being returned - assuming you don't need them. Also check the call parameters you are making from db-lib/ODBC/ADO/etc. Make sure it is a synchronous call and not an asynchronous one.

---