Hi All,

To update my client's and internal SQL Servers I write Scripts that are run in the Query Analyzer. i.e. ALTER TABLE, CREATE INDEX, etc. (Whether this is a GOOD approach or not is up for debate, but it has been reasonably successful)

However, I am having trouble with error handling. Stored Procedures quit when a RETURN is encountered. QA doesn't stop the script! Is there a command I'm missing? Do I need to create a stored procedure, run it, and drop it? Is there another method I SHOULD be pursuing?

Any help would be appreciated?
TIA,