• We see this happen when executing a SELECT INTO with an OPENQUERY

    [font="Courier New"]SELECT ... INTO tablename FROM OPENQUERY(linkedserver,'sql statement')....[/font]

    The workaround we have found is to use a global temp table for the target of the INTO, as in

    [font="Courier New"]SELECT ... INTO ##globaltemptable FROM OPENQUERY(linkedserver,'sql statement')....[/font]

    and then we copy from the ##globaltemptable to the tablename