Parse/Syntax Check MSSQL
 

Hi

We've got a large sql file which is a concatinated version of all of our stored procedures. We work with MSSQL 2005 but still support MSSQL 2000 as some of our customers still run it.

During a QA or a Release build we use the 'Run SQL' to our QA database. However before this is run, or in a basic commit build it would be nice to be able to do a syntax check on the SQL to ensure nothing silly has been introduced.

So i'm looking for a way to do this as a step in Visual Build. I can't see anything built into Visual Build or with the OSQL commandline, so perhaps a third party option that someone knows about?
The other alternative would be something I can plug into our c# app that concatinates the files.

Thanks.

Thank you, that does the job! :)