Export (0) Print
Expand All
Expand Minimize

xp_deletemail

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Deletes a message from the Microsoft® SQL Server™ inbox. xp_deletemail is used by sp_processmail to process mail in the SQL Server inbox.

Syntax

xp_deletemail {'message_number'}

Arguments

'message_number'

Is the number (assigned by xp_findnextmsg) of the mail message in the inbox that should be deleted. message_number is varchar(255), with no default.

Return Code Values

0 (success) or 1 (failure)

Result Sets

xp_deletemail returns this result set when passed a valid message ID.

The command(s) completed successfully.
Remarks

Any failure except an invalid parameter is logged to the Microsoft Windows NT® application log.

xp_deletemail deletes message, but does not delete any attachments. You must delete attachments manually. You can suppress the generation of attachments by setting the suppress_attach parameter for xp_readmail to TRUE. For more information about security issues with attachments, see xp_readmail.

xp_deletemail does not keep a log of deleted messages or users who deleted the messages. This may cause auditing problems in an environment where several users have permission to execute xp_deletemail. To minimize this problem, limit permissions for xp_deletemail to members of the sysadmin fixed server role.

Permissions

Execute permissions for xp_deletemail default to members of the sysadmin fixed server role but can granted to other users. However, for security reasons, you should limit permissions for this stored procedure to members of the sysadmin fixed server role.

Examples

This example deletes the message ID supplied from xp_findnextmsg. The value from xp_findnextmsg is placed in the local variable @message_id.

DECLARE @message_id varchar(255)
SET @message_id = 'XA17' -- Setting to a value would go here.
USE master
EXEC xp_deletemail @message_id

See Also

sp_processmail

System Stored Procedures (SQL Mail Extended Procedures)

xp_findnextmsg

xp_readmail

xp_sendmail

xp_startmail

xp_stopmail

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft