title: TSQL - create a stored proc inside a transaction statement
body: <p>I have a sql script that is set to roll to production.  I've wrapped the various projects into separate transactions.  In each of the transactions we created stored procedures.  I'm getting error messages</p>
  
  <p>Msg 156, Level 15, State 1, Line 4
  Incorrect syntax near the keyword 'procedure'.</p>
  
  <p>I created this example script to illustrate</p>
  
  <pre><code>Begin Try
  Begin Transaction 
      -- do a bunch of add/alter tables here
      -- do a bunch of data manipulation/population here
  
      -- create a stored proc
    create procedure dbo.test
    as
    begin
      select * from some_table
    end
  Commit  
  End Try
  Begin Catch
      Rollback  
      Declare @Msg nvarchar(max)
      Select @Msg=Error_Message();
      RaisError('Error Occured: %s', 20, 101,@Msg) With Log;
  End Catch
  </code></pre>
  
  <p>The error seems to imply that I can't create stored procs inside of transaction, but I'm not finding any docs that say otherwise(maybe google isn't being freindly today).</p>