Event Handling is a major part in any application development that includes the error-handling code that is producing errors. Until previous versions of SQL Server capturing error-handling code is bit hard to implement, as you may be aware within SQL 2005 TRY and CATCH are new methods to make your life easier, these two constructs allow you to handle transaction abort errors that would otherwise have resulted in the termination of a batch, provided that those errors do not cause severance of the...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/t-sql/archive/2007/12/10/2885.aspx