USP_DATAFORMTEMPLATE_EDIT_RECOGNITIONANONYMOUSSETTINGS

                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RECOGNITIONANONYMOUSSETTINGS 
                (
                    @CHANGEAGENTID uniqueidentifier = null,
                    @DEFAULTANONYMOUSRECOGNITION bit
                )
                as

                 set nocount on;

                          if @CHANGEAGENTID is null  
                              exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                          declare @CURRENTDATE datetime
                          set @CURRENTDATE = getdate()

                          begin try
                              update dbo.RECOGNITIONDEFAULT set
                                  DEFAULTANONYMOUSRECOGNITION = @DEFAULTANONYMOUSRECOGNITION,
                                  CHANGEDBYID = @CHANGEAGENTID,
                                  DATECHANGED = @CURRENTDATE

                          if @@ROWCOUNT = 0
                          begin

                            insert into dbo.RECOGNITIONDEFAULT
                            (
                              ID,
                              DEFAULTANONYMOUSRECOGNITION,
                              ADDEDBYID,
                              CHANGEDBYID,
                              DATEADDED,
                              DATECHANGED
                            )
                            values
                            (
                              newid(),
                              @DEFAULTANONYMOUSRECOGNITION,
                              @CHANGEAGENTID,
                              @CHANGEAGENTID,
                              @CURRENTDATE,
                              @CURRENTDATE
                            )
                          end
                          end try
                          begin catch
                              exec dbo.USP_RAISE_ERROR
                              return 1
                          end catch

                      return 0;