Kinook Software Forums

Kinook Software Forums (
-   [VBP] Third Party Tools (
-   -   Parse/Syntax Check MSSQL (

Tony 04-30-2008 04:42 AM

Parse/Syntax Check MSSQL

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.


kinook 04-30-2008 07:30 AM

Tony 04-30-2008 08:16 AM

Thank you, that does the job! :)

All times are GMT -5. The time now is 02:32 AM.

Copyright 1999-2019 Kinook Software, Inc.