User access on Temp tables question

[LucieLastic]

hi

I'm in the process of writing a Stored Procedure which creates a couple of temporary tables. The data can be different for each user, so my question is, if 2 users run the same Stored Proc at the same time, will they both try to access the same temp table or will 2 separate instances of the temp table be created, each one being dedicated to individual user's session?

lou

 

[bdiaz]

You have both types of temporay tables
Tables created as "create table tempdb..t1" are shared anong all connections, and tables created as "create table #t1" has a different table for each connection.

 

[LucieLastic]

hi dbiaz

I need the #t1 one. Thanks for that.

lou