开发者

SQL Server 2005 sp_send_dbmail

开发者 https://www.devze.com 2022-12-31 20:33 出处:网络
When we use sp_send_dbmail to send email with attachment, the attachment gets copied into a folder inside C:\\Windows\\Temp. As we have many emails to be sent every day, the temp folder grows rapidly.

When we use sp_send_dbmail to send email with attachment, the attachment gets copied into a folder inside C:\Windows\Temp. As we have many emails to be sent every day, the temp folder grows rapidly. This is the case with SQL Server 2005. We noticed that, with SQL Server 2008, we dont see these file under temp folder.

Is there any setting to turn the above behavior off?

Does SQL Server 2008 store the files in any other folder and not in temp?

Appre开发者_StackOverflow社区ciate your help and time.

Thanks.


Not a direct answer to your question, but a possible work around:

How about deleting the older temp files, on a set schedule, to keep the folder smaller?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号