Hi Kurt,
I tried setting the asynchronous property to .T. with SQLSETPROP() I executed that line but my VFP app doesn't let me exit it before the SQLEXEC() call is done. So I guess I'll try creating a job and use msdb.dbo.sp_start_job but, by now DTS package is running fine by calling it with master.dbo.xp_CmdShell. I'll do the "job" method later, now I have more important tasks to do.
Thank you very much,
Luis
>Luis,
>
>Look into the SQLSETPROP() and try setting the asynchronous property to .T.. This should do want you want but I haven't tried it so I can't say for sure. Another option is to create a job that executes the stored procedure and then use SPT to start the job by calling msdb.dbo.sp_start_job. As soon as the job starts, the procedure returns control back to your application.
>
>USE msdb
>EXEC sp_start_job @job_name = 'Nightly Backup'
>
>Kurt
>