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 2000 Forums
 SQL Server Development (2000)
 deleting mails from 'sent item' list

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-10 : 08:08:50
Sargum writes "We have a VB program that creates reports and sends them to respective addresses using xp_sendmail system stored procedure.
But since the number of e-mails is huge, the 'sent items' box gets full and repeatedly we have to manually delete the messages and run the program a number of times. Is there a stored proc in sql server to delete the the items from 'sent items' folder so that we don't run out of space.
Thanks!"
   

- Advertisement -