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?