Options

How to prevent unexpected client version update

rmv_RUrmv_RU Member Posts: 119
edited 2013-06-24 in NAV Tips & Tricks
We often use different versions of Nav for different projects. That's why we always use this trigger to prevent unexpected version update:
go
create trigger [dbo].[tr_ndo_property] on [dbo].[$ndo$dbproperty]
for update
as
declare @new_identifiers varchar(2000)
declare @old_identifiers varchar(2000)
declare @new_database_version int
declare @old_database_version int
select @new_identifiers=identifiers from inserted
select @new_database_version=databaseversionno from inserted 
select @old_identifiers=identifiers from deleted
select @old_database_version=databaseversionno from deleted 
IF @new_identifiers<>@old_identifiers 
 or @old_database_version<>@new_database_version 
 begin
 raiserror('Client version update is disallowed!', 16, 1)
 if @@TRANCOUNT <> 0 rollback transaction 
end
GO

Looking for part-time work.
Nav, T-SQL.
Sign In or Register to comment.