title: Error: There are uncommitted transactions
body: <p>I open a new window in SSMS and run this:</p>
  
  <pre><code>SET ANSI_DEFAULTS ON 
  GO
  
  CREATE PROCEDURE [dbo].[zzz_test2]
  (
      @a    int
  )
  AS
      SET NOCOUNT ON
      SET @a=1
      RETURN 0
  GO
  </code></pre>
  
  <p>and then close the window, which results in this warning:</p>
  
  <p><code>There are uncommitted transactions. Do you wish to commit these before closing the window?</code></p>
  
  <p>what is going on??</p>
  
  <p>when I open a new SSMS window and run this:</p>
  
  <pre><code>SET ANSI_NULLS  ON  
  GO    
  
  CREATE PROCEDURE [dbo].[zzz_test2]
  (
      @a    int
  )
  AS
      SET NOCOUNT ON
      SET @a=1
      RETURN 0
  GO
  </code></pre>
  
  <p>and close the window, I get no warning.</p>