Sintaxe geral

BEGIN TRY

{ sql_statement | statement_block }

END TRY

BEGIN CATCH

[ { sql_statement | statement_block } ]

END CATCH [ ; ]

Exemplo:

begin try
insert into servidor.racom.dbo.fornecedor (cd_pes_fornec,cd_login) values (@cdpes,1)
end try
begin catch

     print 'erro'
end catch