Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: Linked server Insert problem

    No. Nothing leads me to a valid answer. In the end, I've adopted the following syntax (a bit complex with lot of parameters)

    SET @SQL_Cmd = 'EXECUTE (''INSERT INTO EntityMaster (id,...

  • RE: Linked server Insert problem

    My initial suspect was that OPENQUERY delays or uses a local cache. When I found that Master record was inserted in MySQL table I cannot explain why foreign key check...

  • RE: Linked server Insert problem

    Yes, with a SELECT * FROM OPENQUERY(EXTSYS, 'SELECT * FROM EntityMaster WHERE id=131177') put between first and second INSERT, I can see inserted row (that makes me crazy :crazy: ).

    Even...

Viewing 3 posts - 1 through 4 (of 4 total)