Two same temp tables in two diffrent stored procedures

[kalam]

Hi, I am using two temp tables of same name e.g. #temp in two diffrent sored procedures of diffrent name e.g sp1 and sp2, in SQL server 2005. I am just not sure whether there will any problem when users will be accessing the two stored procedures simultanously. Please help. Kalam.

[KANGAROO_]

y u can simultaneously bt not concurrently........

manoj Kumar Jha "Learn to smile at every situation. See it as an opportunity to prove your strength and ability."

[pmarfleet]

Temp tables only have scope within a particular session. If a stored procedure is invoked by 2 different processes, each process will have its own temp tables.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[veereshIndia]

Hi, You can use as many temp table you want.But after doing transaction you have to delete those temp table. Regard's Veeresh

i want to join this group