title: Command(s) completed successfully but... the tables are not created
body: <p>I backed up my database table's and entire schema into .sql script using Visual Studio's <a href="http://weblogs.asp.net/jgalloway/archive/2006/12/29/tip-use-the-database-publishing-wizard-to-script-your-table-data.aspx" rel="noreferrer">Database Publishing Wizard</a>.</p>
  
  <p>I then tried to re-create those tables on another PC, not before re-creating the database itself, with the same exact name and everything (using a script that I created via SSMS's <code>Script Database as)</code>.</p>
  
  <p>I then open that tables .sql file using SSMS and execute it. </p>
  
  <p>SSMS reports:</p>
  
  <blockquote>
    <p>Command(s) completed successfully</p>
  </blockquote>
  
  <p>But examining Object Explorer reveals that <strong>no tables were created</strong>.</p>
  
  <p>Why is this happening?</p>
  
  <p>What have I missed?</p>