Mark,
>Is it a VFP command? I am looking to pause execution from VFP that runs a SQL SP.
No it's a SQL server command.. that appeared to be what you were asking for *g*.
On VFP if you have a synchronous connection VFP will wait until the SQL function call has returned. If you have an asynchronous connection I recommend you use a timer based polling loop.
>>Look at the WAITFOR command.
>>
>>>Is there a way of pausing SQL Server SP execution?