Re: issues with SQL task and the PRINT statement in external .sql files

> Hello,
>
>   So I have been banging my head against a wall it seems because I have
> been trying to automate the database build and deployment process for
> our software.  The goal I have is using ANT and the sql task, to execute
> an existing .sql file that was developed and placed in SVN.  I am having
> an issue that when I execute the scripts using the ant SQL task, it does
> not give me the results for the sql statement PRINT.  It just seems to
> ignore it and not give me the message in the output.  All I get is "0
> rows affected".  This is frustrating because I can't seem to get ANT to
> give me the message.  The print statements contain information that is
> good for logging what the results of the script.  
>
>  
>
> The manual process has been to just run the scripts using enterprise
> manager and copy the results into a file and just save the file.  If I
> didn't need this to run on a unix machine and connecting to MS-SQL
> databases I would be using something like sqlplus or the sqlcmd tool on
> windows.  But I would like to use ANT to do all the execution of the
> scripts.  Any suggestions?  Is there a better solution out there?
>

>  
>
> Here is an example of a simple script that will illustrate what I am
> trying to do....
>
>  
>
> PRINT 'This is a message to signify that a select statement is going to
> be run:'
>
> SELECT * FROM SomeTable
>