USP_DATAFORMTEMPLATE_EDIT_DATABASEMAILSETTINGS

The original save implementation of the Database Mail Settings form preserved for backwards compatibility.

Parameters

Parameter	Parameter Type	Mode	Description
@ENABLED	bit	IN	Enabled
@PROFILENAME	nvarchar(128)	IN	SQL Server Database Mail Profile
@APPROOTURL	nvarchar(1024)	IN	Application URL root
@SELECTEDDATABASE	nvarchar(128)	IN	Selected database
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_DATABASEMAILSETTINGS] (
  @ENABLED bit,
  @PROFILENAME nvarchar(128),
  @APPROOTURL nvarchar(1024),
  @SELECTEDDATABASE nvarchar(128),
  @CHANGEAGENTID uniqueidentifier = null
)
as begin
  declare @APPLICATIONLINKFORMATCODE tinyint;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_DATABASEMAILSETTINGS] @APPLICATIONLINKFORMATCODE output;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_DATABASEMAILSETTINGS_2]
    @ENABLED,
    @PROFILENAME,
    @APPROOTURL,
    @SELECTEDDATABASE,
    @CHANGEAGENTID,
    @APPLICATIONLINKFORMATCODE;

  return 0;
end