USP_DATAFORMTEMPLATE_EDIT_BBDWVALIDATIONPARAMETERS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBDWVALIDATIONPARAMETERS (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @INCLUDEEXTENSIONS bit,
    @RUNAFTERETL 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.[OLAPDATASOURCEVALIDATIONPARAMETERS] set
              INCLUDEEXTENSIONS = @INCLUDEEXTENSIONS,
              RUNAFTERETL = @RUNAFTERETL,
              NAME = 'Default Validation',
              CHANGEDBYID = @CHANGEAGENTID,
              DATECHANGED = @CURRENTDATE
          where [OLAPDATASOURCEID] = @ID

    end try

      begin catch
          exec dbo.USP_RAISE_ERROR
          return 1
      end catch


return 0;