• It's interesting to note that it is assumed that the remote server is a SQL Server.

    I use OpenQuery to retrieve data from a DB2 Database via a Linked Server.

    DB2 doesn't have a "tempdb.dbo.a" syntax.

    David