set xact_abort on
go

begin transaction
go

UPDATE dbo.AnagraficaStati SET 
  ShowArticolo=1
  WHERE IdxStato=1
go

commit transaction
go

-- registro versione...
INSERT INTO [dbo].[LogUpdateDb] ([Versione],[Data]) VALUES(302, GETDATE())
GO