title: Syntax error in SQLCMD SQL script?
body: <p>I'm currently trying to get a SQL script working for SQL Server 2005. I'm using <code>SQLCMD</code> to execute the script and it fails giving me an "Error: Syntax error at line 7 near command ':r'" error.</p>
  
  <p>The script:</p>
  
  <pre><code>--Main Script--
  SET NOCOUNT ON
  GO
  
  :on error exit
  
  :r C:\Documents and Settings\ZSmith\My Documents\Scripts\CreateDatabase
  :r C:\Documents and Settings\ZSmith\My Documents\Scripts\CreateTables
  </code></pre>
  
  <p>I can provide the other SQL scripts if needed but they function fine on their own. I'm just trying to automate the entire process.</p>