• As Mithun wrote you should have a look to TRY-CATCH blocks in SQL Server 2005.

    Greets

    Flo