"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:ej7et0980uvbk8n3nheabcvn0lfq57as4a@4ax.com...
> 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)

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?