Friday, May 4, 2018

we create same Local temp table in different sessions in SQL Sever ? If we can create how it will be saved in TempDB?

I have tried to create a Local Temp Table ( with the name of #temp) in 2 session in sql sever.
Tables has been created successfully in both the sessions with the same Local Temp Table(#temp) name.


After successfully created temp tables ,I have checked the TempDB to know the how tables will be saved. Please check below screen shot for your reference.




Tables has saved with unique extension number based on session.


Conclusion : We can created the same temp table in different sessions.
Please correct me if I am wrong.