Link Server Global Temp table RRS feed

  • Question

  • All,

    I m working on SQL server 2000, and got two server.

    Server 1

    Server 2

    Server2 calls a procedure which is located at server1 and stores the o/p in Global Temp Table. Whts the best way to reterieve the details on SERVER 2.

    I have tried following nothing has worked.

    SELECT * FROM OPENQUERY(linkserver1,'SELECT * FROM ##tmp') AS a

    SELECT * FROM linkserver1.dbo.##tmp

    Any updates will really appreciated.
    Monday, January 4, 2010 1:10 PM

All replies

  • How the full code looks like? I'm afraid that at the very moment the call producing the global temptable on the other server completes (the OPENQUERY returns), the temptable is dropped. Did you try it in a single openquery?

    -- Erik -- http://blog.rollback.hu
    Thursday, January 7, 2010 4:23 PM