Using task to create SQLServer stored procs

[Chris Doran <cd...@pts.com>]

Hi All

I've written a build.xml that retrieves several sqlserver scripts from a 
VisualSourceSafe repository. Each of these creates a stored procedure that 
contains microsoft specific wrapper code to drop the stored proc if it 
already exists before recreating it. In essence each script contains 
batches that are separated by the text 'GO'.

Setting the src task delimiter attribute to 'GO' ensures each script runs 
correctly.

However, when I view my stored procs via sqlserver's enterprise manager, 
each stored proc appears as a single line, making it difficult to read.

Any way I can maintain the cr/lf's in the original script files ?

Thanx


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org