Re: #Temp table question

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 01/01/05

  • Next message: MichaelK: "Re: #Temp table question" 
    Date: Sat, 01 Jan 2005 23:05:40 +0100

    On Fri, 31 Dec 2004 16:12:06 -0800, MichaelK wrote:

    >I'm not sure if I understood this correctly.
    >If I create a temporary table with the name #SomeTempTab,
    >can anybody else see this table while I'm using it and before I drop it.
    >So if two users at the same time trying to create the table with this name
    >will they be different for each user or there will be a conflict?

    Hi Michael,

    There will be no conflict. SQL Server will generate a connection-specific
    suffix to create a really unique table name in tempdb. Everytime you refer
    to #SomeTempTab, SQL Server will append the suffix and look in "your"
    version of the temporary table.

    Best, Hugo 

    -- 
(Remove _NO_ and _SPAM_ to get my e-mail address)
  • Next message: MichaelK: "Re: #Temp table question"