>>Mike, raising that error in QA also 'worked' - in that it prevented the rest of the script from running
>
>Really?!? I tried it but nothing happen
>
>SELECT 'hello'
>RAISERROR ('an error occurred', 16, 127)
>GO
>SELECT 'world'
>GO
>
>This doesn't terminate the script. What did you do?
>
>-Mike
if @cVersion not in ('DB4', 'DB5') raiserror ('DATABASE VERSION ERROR!', 127, 1) with nowait, log
it's ugly - but kills the script
HTH,
Ken B. Matson
GCom2 Solutions