there are no parameters you can pass to osql.exe, isql.exe, or sqlcmd.exe to check syntax. Depending on the script, you could try putting begin transaction and rollback transaction at the beginning and end of it so no data changes.
If the script takes 4 hours to run though, this might be a problem though.... Anthony On Thu, Apr 9, 2009 at 9:41 AM, Ruben Willems <[email protected]> wrote: > Hi > > > maybe you can use osql.exe or isql.exe from the command line > > > with kind regards > Ruben Willems > > On Thu, Apr 9, 2009 at 10:34 AM, Outlaw1803 <[email protected]> wrote: >> >> Hi, >> >> I have an app that combines multiple .sql files as 1 script. I would >> like to do some validation tests on the script to ensure there are no >> syntax errors (usually I would parse the script in SQL2005/2008) >> >> Is there an automated way of doing this? What tools can I use to >> perform this task? >> >> Any ideas whould be appreciated >> >> Regards >
