title: TransactSQL to run another TransactSQL script
body: <p>I have 10 transact SQL scripts that each create a table and fill it with data.</p>
  
  <p>I am attempting to create 1 master sql script that will run each of the 10 other scripts.</p>
  
  <p>Is there a way with TSQL / TRANSACTSQL for Microsoft SQL Server 2008 to execute another tsql script from within the current tsql script?</p>
  
  <p>This is intended to be run through the SQL Server Management Studio (SSMS).</p>
  
  <p>Thanks!</p>