set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTERTRIGGER[dbo].[mlsCheckAutoDetailSave] ON[dbo].[AutoDetailSave] FORINSERT, UPDATE AS BEGIN IFNOTEXISTS ( SELECT resultsNumber FROM RESULTS_IDX WHERE resultsNumber = (SELECT MLS FROM INSERTED) ) BEGIN RAISERROR('Transaction Failed.',16,1) ROLLBACKTRAN END END