Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Service Broker (2005)
 DBMAIL Temp Directory

Author  Topic 

jmcl
Starting Member

6 Posts

Posted - 2007-06-09 : 15:05:39
I've been using SQL 2005 DBMail fro a couple months now with little problem until last night. I discovered that all of the attachments are moved to the temp directory used the the login account, but apparently not deleted. Last night it ran out of space. I can create a batch command to delete the files, but wondered if there was some setting in SQL server that would allow it to automatically clean up after itself. Any suggestions?

John
   

- Advertisement -