You could try using "try...catch..."

BEGIN TRY

{ sql_statement | statement_block }

END TRY

BEGIN CATCH

[ { sql_statement | statement_block } ]

END CATCH

[ ;...