TR_DATATUNEUP_LIMIT

Definition

Copy


                    CREATE trigger TR_DATATUNEUP_LIMIT on dbo.DATATUNEUP after insert
                    as begin
                        begin try
                            if (select count(ID) from dbo.DATATUNEUP) > 1
                            begin
                                raiserror('BBERR_DATATUNEUP_ROWEXISTS : Data tune-up settings already exists.', 13, 1);
                            end
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            rollback tran;
                        end catch
                    end