Just curious as I had this in an interview. Actually it was for an Oracle Developer job but I presume it works the same way in SQL Server? Please bark if it doesn't. I was asked where an error goes if it doesn't meet any of the trigger criteria and yet is still an error someway or another. Isn't there a general safety net functionality, ie an ELSE condition for triggers? Obviously, I didn't know the answer. Please elaborate.
The error would go free, riding into the sunset, of course.
Actually, Oracle has much more error handling abilities in PL/SQL than T-SQL, so the Oracle question is more difficult. T-SQL is catching up, as they have introduced the try-catch syntax in 2005. Still, not all errors can be caught, and those errors are sent to the calling program to be dealt with however the calling program sees fit.