>Are you asking if you can pass the contents of the stored proc to SQL instead of having the SP exist in a compiled state in SQL? If so, the answer is yes. You can wite all the code and pass it all as a string in place of a query (via SQLEXEC) and it will get compiled and executed in SQL Server. The code would have to be SQL code, not VFP code. Why wouldn't you want to just write the stored proc in SQL?
Because, this is a VFP DBF. I am not using SQL Server.