title: what will happen to my temp table in mssql if multiple users use my application?
body: <p>I am running a sql query which involves creating a temp table to do some processing on it. My question is what will happen to my temporary sql table if lets say 10K users a using my app.I am creating and inserting data into the table as follows</p>
  
  <pre><code>BEGIN TRANSACTION;
  BEGIN TRY
  IF OBJECT_ID('tempdb..#Temp') IS NOT NULL BEGIN   DROP TABLE #Temp; END
  Select * Into   #Temp From     [Booking]  where purchaseorder='123'
  -- Do some processing on temp table and 
  -- save data into some other table.
   IF OBJECT_ID('tempdb..#Temp') IS NOT NULL BEGIN DROP TABLE #Temp; END 
  
  END TRY
  BEGIN CATCH
      IF @@TRANCOUNT &gt; 0
          ROLLBACK TRANSACTION;
  END CATCH;
  
  IF @@TRANCOUNT &gt; 0
      COMMIT TRANSACTION;
  GO
  </code></pre>
  
  <p>Can it be that my temporary will get dropped by some other user , other than the user who created it?
  my application is in asp.net</p>
  
  <p>Thanks</p>