TR_CONSTIT_SECURITY_ATTRIBUTE_INSERT

                    CREATE trigger dbo.TR_CONSTIT_SECURITY_ATTRIBUTE_INSERT on dbo.CONSTIT_SECURITY_ATTRIBUTE after insert not for replication
                    as begin
                        set nocount on;

                        declare @ID uniqueidentifier;
                        declare @NAME NVARCHAR(100);
                        declare @CHANGEAGENTID uniqueidentifier;

                        declare INSERTED_CURSOR cursor local fast_forward for
                            select
                                [ID],[NAME],[CHANGEDBYID]
                            from
                                INSERTED;

                        open INSERTED_CURSOR;

                        fetch next from
                            INSERTED_CURSOR
                        into
                            @ID,@NAME,@CHANGEAGENTID;

                        while @@fetch_status = 0 begin
                            exec USP_CREATE_CONSTIT_SECURITY_ATTR_VIEW @ID, @NAME,@CHANGEAGENTID;

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

                        close INSERTED_CURSOR;
                        deallocate INSERTED_CURSOR;
                    end