I know that SQL 2005 has been out for a while now, but I did not do ANY sql for over a year. Anyway, anyone that has had to write anything more than trival procs knows that error handling can be a pain. In the past you have had to do something along the line of the following IF ( @@ERROR > 0...