View Single Post
  #1  
Old 04-30-2008, 04:42 AM
Tony Tony is online now
Registered User
 
Join Date: 04-24-2008
Location: London
Posts: 4
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.
Reply With Quote