Post reply

temp table

  • August 3, 2009 at 10:05 pm

    #135047

    what is the difference between local temp table and global temp table?

  • August 3, 2009 at 10:09 pm

    #1034060

    a local temp table is available only to the connection that creates it (that SPID).

    The global temp table is for all connections.

  • August 3, 2009 at 10:14 pm

    #1034061

    it means,

    i opend the sqlserver with windows authentication mode and sqlserver authentication mode.

    is global temp table is available in these two connections?

  • August 3, 2009 at 10:40 pm

    #1034068

    Authentication mode does not matter, the rules and availability are the same.

    CEWII

  • August 3, 2009 at 10:59 pm

    #1034071

    thanks Steve and Elloote

  • May 17, 2010 at 4:35 pm

    #1168508

    Is it possible to query from a global temp table from another server via linked server?

    When I use

    SELECT * from linked_server.db.owner.##GlobalTemp

    I get a message:

    Invalid object name ##GlobalTemp

  • May 17, 2010 at 4:40 pm

    #1168511

    dlink (5/17/2010)

    Is it possible to query from a global temp table from another server via linked server?

    When I use

    SELECT * from linked_server.db.owner.##GlobalTemp

    I get a message:

    Invalid object name ##GlobalTemp

    You should start a new thread for this question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 17, 2010 at 5:40 pm

    #1168536

    dlink (5/17/2010)

    Is it possible to query from a global temp table from another server via linked server?

    When I use

    SELECT * from linked_server.db.owner.##GlobalTemp

    I get a message:

    Invalid object name ##GlobalTemp

    Since the ##GlobalTemp table exists in TempDB you could try using this for the db, but I doubt it will work, because the name isn't actually the same within TempDB.

    Why don't you use a created table within the original database?

    Leo

    Striving to provide a better service.

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply