Question about temporary table .

[Calista]

I have a stored procedure that creates a temporary table.
If two people (using the same account) execute the same stored
procedure at the same time, will they overwrite / access the temporary
table ?

Calista.

[John Bell]

Hi

Temporary tables are only visible to the current connection. See

http://msdn.microsoft.com/library/de...es_04_8jtx.asp

The name within the database itself is made unique by SQL Server
e.g.

create table #Test ( id int not null )
select name from tempdb..sysobjects where name like '%Test%'
INSERT INTO #Test ( id ) VALUES ( 1 )
select * from #Test

John

"Calista" <ca***********@hotmail.com> wrote in message
news:e1**************************@posting.google.c om...

I have a stored procedure that creates a temporary table.
If two people (using the same account) execute the same stored
procedure at the same time, will they overwrite / access the temporary
table ?

Calista.

[Dan Guzman]

To add to John's response, local temp tables (single '#') are uniquely
named by SQL Server. It is your application's responsibility to
uniquely name global temp tables ('##') if you need to prevent name
conflicts due to concurrency issues.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Calista" <ca***********@hotmail.com> wrote in message
news:e1**************************@posting.google.c om...

I have a stored procedure that creates a temporary table.
If two people (using the same account) execute the same stored
procedure at the same time, will they overwrite / access the temporary
table ?

Calista.