Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [VBP] Third Party Tools (https://www.kinook.com/Forum/forumdisplay.php?f=3)
-   -   Parse/Syntax Check MSSQL (https://www.kinook.com/Forum/showthread.php?t=3583)

Tony 04-30-2008 04:42 AM

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.

kinook 04-30-2008 07:30 AM

http://msdn.microsoft.com/en-us/libr...8(SQL.80).aspx

Tony 04-30-2008 08:16 AM

Thank you, that does the job! :)


All times are GMT -5. The time now is 06:54 PM.


Copyright © 1999-2023 Kinook Software, Inc.