I'm yet another user of this great procedure. Lowell, thanks for the work and sharing.

I'm using it to (re)create tables from within a java app. I just have some issue with the GO statement , it always fails just after it.

As a workaround I changed the procedure so that each GO is replaced by a semicolon ';' . That works for indexes but not for triggers('must be the first statement in a query batch').

I guess the GO statement needs the 'newline' & 'carriage returns' before & after. Apparently the CHAR(10) & CHAR(13) are not recognized as such.

Is there any user that solved such a problem ?

Bart

bartvdc