title: Debugging a stored procedure
body: <p>I have the following stored procedure:</p>
  
  <pre><code>USE [OfficeAuto]
  GO
  
  /****** Object:  StoredProcedure [dbo].[INSERT_Project]    Script Date: 09/06/2011 10:42:44 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  
  ALTER procedure [dbo].[INSERT_Project]
  ...
  </code></pre>
  
  <p>When I try to debug this, I cannot step past <code>SET ANSI_NULLS ON</code>.  The debugger just stops.  I thought I could step through a stored procedure just like through code in VS.  Not sure what I am doing wrong.</p>