TR_CONSTIT_SECURITY_ATTRIBUTE_UPDATE (Trigger)

                
                        CREATE trigger dbo.TR_CONSTIT_SECURITY_ATTRIBUTE_UPDATE on dbo.CONSTIT_SECURITY_ATTRIBUTE after update not for replication
                        as begin
                            set nocount on;
                            
                          declare @ID nchar(36);
                          declare @OBJECT_ID int;
                          declare @NAME NVARCHAR(100);
                          declare @CHANGEAGENTID uniqueidentifier;
                            
                            declare INSERTED_CURSOR cursor local fast_forward for
                                select
                                    replace(convert(nchar(36),ID),'-','_') AS IDSTRING ,NAME, CHANGEDBYID
                                from
                                    INSERTED;
                                    
                            open INSERTED_CURSOR;
                            
                            fetch next from
                                INSERTED_CURSOR
                            into
                                @ID,@NAME,@CHANGEAGENTID;
                            
                            while @@fetch_status = 0 begin

                            UPDATE dbo.IDSETREGISTER SET 
                              NAME= @NAME + ' (Security Group)',
                              DESCRIPTION='Records in Constituent Security Group ' + @NAME, 
                              CHANGEDBYID = @CHANGEAGENTID

                            WHERE DBOBJECTNAME='V_CONSTIT_SECURITY_ATTR_' + @ID;

                                
                                fetch next from
                                    INSERTED_CURSOR
                                into
                                    @ID,@NAME,@CHANGEAGENTID;
                            end
                            
                            close INSERTED_CURSOR;
                            deallocate INSERTED_CURSOR;
                        end