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.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish