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