Although this parameter is optional, at least one of or must be specified, or sp_send_dbmail returns an error. The copy recipients list is of type varchar(max). Is a semicolon-delimited list of e-mail addresses to carbon copy the message to. The recipients list is of type varchar(max). Is a semicolon-delimited list of e-mail addresses to send the message to. If the user does not have a default private profile and there is no default public profile for the database, must be specified. If the user does not have a default private profile, sp_send_dbmail uses the default public profile for the msdb database. When no profile_name is specified, sp_send_dbmail uses the default private profile for the current user. The profile_name must be the name of an existing Database Mail profile. The profile_name is of type sysname, with a default of NULL. Is the name of the profile to send the message from. This stored procedure is in the msdb database. When mail is successfully placed in the Database Mail queue, sp_send_dbmail returns the mailitem_id of the message. The message may include a query result set, file attachments, or both.
Sends an e-mail message to the specified recipients. Applies to: SQL Server Azure SQL Managed Instance
0 kommentar(er)
