TR_SCHEDULINGEXCEPTION_ENSUREONEROW_INSERT

Definition

Copy


                    create trigger dbo.TR_SCHEDULINGEXCEPTION_ENSUREONEROW_INSERT
                        on dbo.SCHEDULINGEXCEPTION
                        after insert
                    as
                    begin
                        set nocount on

                        if (select count(*) from dbo.SCHEDULINGEXCEPTION) > 1
                        begin
                            exec dbo.USP_RAISE_ERROR
                            rollback transaction
                        end
                    end