TR_SESSION_UPDATE_DATACHANGED

Definition

Copy


                    create trigger [dbo].[TR_SESSION_UPDATE_DATACHANGED] 
                        on [dbo].[SESSION
                        for update 
                    as begin
                        set nocount on

                        --Check that MarkingColumnSet cannot be changed if marking columns are in use

                        if update(MARKINGCOLUMNSETID) 
                        begin
                            if (exists (select inserted.MARKINGCOLUMNSETID
                                        from inserted 
                                            inner join deleted on inserted.ID = deleted.ID
                                        where inserted.MARKINGCOLUMNSETID <> deleted.MARKINGCOLUMNSETID
                                            and dbo.UFN_SESSION_MARKINGCOLUMNSET_INUSE(inserted.ID) <> 0))
                                raiserror('BBERR_SESSION_MARKINGCOLUMNSET_INUSE', 13, 1);
                        end
                    end