#Temp table question

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?
Thanks,
Michael
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)
|||Thanks Hugo.
You were helpfull as well as with my another question.
It's what I was looking for.
Regards,
Michael
"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:
>
> 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)