RAISERROR not working as expected

[pandatime]

Hi,

I have this line of code in my proc:

RAISERROR ('Found leftover files, 20, 1)

but when the code reaches this point of execution, it just keeps on chugging along... No, I want the code to STOP running at this point and return the error, whether from a SQL window or from a job. I tried severity 16, that didn't work, but neither does 20.

Help

thanks

 

[pandatime]

ok nevermind, i guess in need to add a "return" as well

 

[danvlas]

If SQL Server 2005 or higher, you could use Try-Catch for greater flexibility.


Daniel Vlas
Systems Consultant