title: Temporary tables in stored procedures
body: <p>I have been wondering about temp tables in sp's and how all that can effect concurrency.
  SP made on a MSSQL 08 server.</p>
  
  <p>If I have a SP where I create a temp table and drop it again like this:</p>
  
  <pre><code>BEGIN
  
  CREATE TABLE #MyTempTable
  (
     someField int,
     someFieldMore nvarchar(50)
  )
  
  ... Use of temp table here
  ... And then..
  
  DROP TABLE #MyTempTable
  
  END
  </code></pre>
  
  <p>This SP will be called very very often, so my question is can there ever occur concurrency issues here?</p>