Home Forums SQL Server 2008 SQL Server 2008 - General Distributed transaction RE: Distributed transaction

  • August 4, 2015 at 11:41 am

    #1817257

    Have you tried

    Set @SQLCMD = 'Select * from openquery(ABCD,"Select * from database.TableName")'

    insert into @TempTableName

    EXEC (@SQLCMD)