Don't want to wait for the results SP Call

[SilentWings]

Hi ppl,

I have a VB program that executes stored procedures in SQLServer2000. I need to launch that execution and don't want to wait for the results of that Stored Procedure Call.

How can I do that?

Thanks in advance...

 

[bboffin]

I assume that you're using an ADO Command object to call the Stored Procedure. If not then you must change your code.

When you call the Execute method of the Command object specify adAsyncExecute or adAsyncFetchNonBlocking in the Options parameter.

When the execution is complete an ExecuteComplete event will be raised on the Connection object so you'll need to have declared that WithEvents.

You can find all the details in MSDN.

 

[nigelrivett]

Or if you don't want the results at all then put the sp call into a table and have a scheduled job on the server that runs commands from that table.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.