>I'm stumped by the error in the title on the 2nd line. I catched this in the error log at a clients, so no repro.
>Its intermittend.
>
>

SELECT InvestLimits
>SET ORDER TO Itemid

>
>
>There is no variable called Investlimits, just an alias. The first line has no problem, but it bangs on the SET ORDER TO ItemID.
>
>Anyone have an idea?

Is this running in a visual environment (i.e. forms active, grids, browse, etc)? If so, then there may be events (possibly async) interfering...