title: Can't drop temp table SQL
body: <p>Hi Im creating a Temp table and inserting data to the Table. Im going to use the Temp table to Join it to the specific User. </p>
  
  <pre><code>CREATE TABLE #MyTempTable
  (
      UsersId int,
      ValautionCount int 
  )
  
      SELECT
          U.UserId, 
          COUNT(*) AS ValautionCount
      INTO  #MyTempTable
      FROM 
          Users U
          Right JOIN Valuation V ON V.ValuationUser = U.UserId
      GROUP BY 
          U.UserId
  
  
  
  DROP TABLE #MyTempTable
  </code></pre>
  
  <p>When I run this query I get this error : There is already an object named '#Temp' in the database.</p>
  
  <p>But when I run this query <code>DROP TABLE #MyTempTable</code> I get this error: Cannot drop the table '#Temp', because it does not exist or you do not have permission.
  Im using SQL 2012</p>