If I place an event handler on the package level will it capture all events?Mr Shaw

By default, yes, it will capture all events of that type that are raised by any descendant container in the container hierarchy.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Why would you want to put an event handler on a lower level if the highest level captures everything?Mr Shaw

Why would you want to put an event handler on a lower level if the highest level captures everything? Mr Shaw I've no idea. I wasn't suggesting that you should.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Why would you want to put an event handler on a lower level if the highest level captures everything? Mr Shaw To trap one type of event and turn it into something else. For example, let's say I have a container that can fail but I don't want to stop processing. I can set up an event handler at the lower level to trap the failure, and then fire a warning event, while at the same time executing some other piece of code. I can then continue processing without the event handler on the main container firing.