USE [RF_WORLD_NOVUS] GO /****** Object: Trigger [dbo].[FixMaxLevel] Script Date: 04/27/2011 15:55:33 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [dbo].[FixMaxLevel] ON [dbo].[tbl_general] FOR UPDATE AS SET NOCOUNT ON; IF UPDATE (MaxLevel) BEGIN update tbl_general set MaxLevel = 65 where Maxlevel = 66 END GO