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