>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