Stored Procedure Inquiry... Pls. Help... 1

[coolphilboy]

How will i know if an SQL Server stored procedure w/c is called via VB App is finished or still running? TIA...

 

[dannyh]

How are you calling the stored procedure in the first place ?

Dan.

 

[coolphilboy]

Would like to rephrase my question. I would like my VB App to call an sql server stored procedure then wait until the stored procedure is done before my application continue... is it possible, pls tell me how? TIA again.

 

[chiph]

coolphilboy -

That is the default behavior when you call a stored procedure. The only way to do it differently is to use asynchronous ADO calls, which is something I've never felt obligated to use.

Chip H.

 

[coolphilboy]

Thanks a lot chip! just for clarification.