current position:Home>What attachments do SQL server send mail with?

What attachments do SQL server send mail with?

2022-02-02 19:36:01 CSDN Q & A

SqlServer It has the function of sending e-mail , When sending, you can bring attachments .

------------------------------------------------------------------------                -- Call SP Generate CSV Documentation , Then save it to a fixed path  Set @ExcelFileName='\\.........\ List of unrepaired equipment [email protected]'                                           -- Email EXEC msdb..sp_send_dbmail @profile_name='SQL_mail',     @recipients ='',                         @subject = '',               @Body ='',        @file_attachments = @ExcelFileName    

The problem is , How to be in SSMS Which attachments have been sent in the query ?

Refer to the answer 1:

see msdb..sp_send_dbmail Source code storage procedure , See if the attachment or attachment directory is stored in a table in the database , If there is , Then open the corresponding table , To view the

Refer to the answer 2:

copyright notice
author[CSDN Q & A],Please bring the original link to reprint, thank you.

Random recommended