- Simple: is the fastest batch parsing mode. It simply identifies batches in the source script with very little overhead.
- Common: the source scripts are parsed first to remove T-SQL comments, and then batches parsing takes place
- Thorough: the source scripts are parsed to remove comments, string constants, dynamic scripting and then the batch parsing takes place. The "Thorough" mode can take significantly longer than the other parsing modes. If you know that the source files do not contain dynamic scripting, Common or Simple mode will do the job well.
xSQL Script Executor is a free utility that provides for executing multiple T-SQL scripts against SQL Server. You can download your copy of xSQL Script Executor from: http://www.xsql.com/download/script_executor/