>>Run SQL Server Profiler and see what is executed on SQL Server.
>
>When I run it straight from SMS, it runs fine, it's when I call it from my VFP form that I get this error, so how would I do that?
What do you see in the SQL Server Profiler when you run it from VFP?
If it's not broken, fix it until it is.
My Blog