title: SQL Server Management Studio problem creating scripts of procedures
body: <p>The stored procedure scripts that SQL Server Management Studio 2005 generates for me are like:</p>
  
  <pre><code>SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER OFF
  GO
  IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[APY_SP_ACH_Transmit_Finish]') AND type in (N'P', N'PC'))
  BEGIN
  EXEC dbo.sp_executesql @statement = N'
    ...
    print ''arg!, all the quotes are escaped''
    ...
   '
  END
  </code></pre>
  
  <p>so all the quotes are escaped.  is there a way or option to turn this off?</p>
  
  <p>in SQL Server Management Studio 2005. I do the following:</p>
  
  <p>1) In Object Explorer, locate the procedure I want to script out<br>
  2) right click, and select script stored procedure as "Create To"<br>
  3) selecting file or clipboard has the same effect.</p>