Perfect. Once again Sergey, you da man!

>Perry,
>
>If you have enough rights, you can use SQLEXEC() to send CREATE PROCEDURE script to SQL Server. Check Re: Execute .sql file Message #976613
>
>>I'm working on my contract helping to export the accounting data from the company I worked at that went bellyup.
>>
>>I need to get some SQL Server data into VFP. We created a new SP that formats the data how I need it. I'm going to have to run my conversion program against 40 or so databases.
>>
>>Is there a way to automate loading this new SP into a database I'm getting ready to convert?
>>
>>Thanks.
>>
>>PF