title: SQL Server project executing multiple script post deploy
body: <p>I have a SQL Server 2008 DB Project, and want to execute multiple scripts, in order, on post deploy.</p>
  
  <p>I've added a <code>PostDeploy.Sql</code> script to a scripts folder, and marked that as <code>PostDeploy</code>, and that works fine. I'm aware that only one script can be marked as post deploy; so I thought I could do this within the script:</p>
  
  <pre><code>-- Post Deploy stuff
  SELECT * FROM MYTABLE
  GO
  
  :r RunPostDeploy2.sql
  GO
  </code></pre>
  
  <p>Where <code>RunPostDeploy2.sql</code> is located within the same directory as a link. I've tried copying the file locally, but the issue seems to be the use of <code>:r</code>.</p>
  
  <p>Is it possible to call external scripts from post deploy in this way and, if so, how?</p>