set xact_abort on
go

begin transaction
go

set ANSI_NULLS on
go

/*************************************
* STORED PROCEDURE stp_STM_setInsEnabled
* 	imposta stato amcchian x permettere o meno caricamento
*
* modif.:	S.E.L.
* il:		2014.01.10
**************************************/
create PROCEDURE stp_STM_setInsEnabled
(
	@idxMacchina	NVARCHAR(50),
	@insEnabled		BIT
)
AS

-- ATTIVO/DISATTIVO il caricamento degli eventi
UPDATE	DatiMacchine
    SET	insEnabled = @insEnabled
WHERE	IdxMacchina = @IdxMacchina

RETURN
go

commit
go





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

SELECT  TOP 10 * FROM LogUpdateDb ORDER BY Versione DESC
GO