title: Sql server 2008, are temp tables unique
body: <p>In my server code, I create a temp (named #temp) table, insert some data and then delete the temp table. If more than 1 users were to run this section of the code (creating of the temp table) concurrently, would sql server 2008 create a temp table per user or does it create 1 'global' temp table? If its one table, I assume I would run into trouble when the same table is created more than once?</p>