title: Stored Procedure: There is already an object named '#columntable' in the database
body: <p>Please see the code below:</p>
  
  <pre><code>SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE PROCEDURE Test
  AS
  BEGIN
      begin
      select * into #dbreviews from dbreviews
      end
  
      drop table #dbreviews
  
      begin
      select * into #dbreviews from dbreviews
      end
  
  END
  GO
  </code></pre>
  
  <p>The error I get is: </p>
  
  <blockquote>
    <p>There is already an object named <code>'#dbreviews'</code> in the database.</p>
  </blockquote>
  
  <p>Questions like this: <a href="https://stackoverflow.com/questions/4245444/there-is-already-an-object-named-columntable-in-the-database">There is already an object named &#39;#columntable&#39; in the database</a> are telling me this should be possible.</p>