>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?
Run SQL Server Profiler ans see what VFP sends to SQL Server.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.