>This code:
>
>
>
>iResult = SQLEXEC(._iSQLConnHandle, [EXEC sp_GetVehicle @vehiclekey=1], sTableName)
>
>
>generates the error "Could not find stored procedure 'EXEC sp_GetVehicle @vehiclekey=1'"
>
Not directly related, but generally using sp_ as a prefix on your stored procedures is discouraged. SQL Server uses that for it's own stored procs and will search its list of SP if it sees "sp_" first. If it can't find it, it will then look in the user defined listed of stored procs. That means you'll pay a performance hit on every call (since it has to check to see if it's an internal SP first).