title: SQL: There is already an object named X in the database
body: <p>This is my entire code so far</p>
  
  <pre><code>select Region
      into #C
      from ResearchDB.dbo.tC
      where Tier=0
  </code></pre>
  
  <p>But I already get an error:</p>
  
  <pre><code>There is already an object named '#C' in the database.
  </code></pre>
  
  <p>Now if I comment the line " into #C" out, it works perfectly. Whats going on??</p>