Export (0) Print
Expand All
Expand Minimize

xp_stopmail

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Stops a Microsoft® SQL Server™ mail client session.

Syntax

xp_stopmail

Return Code Values

0 (success) or 1 (failure)

Result Sets

xp_stopmail returns this message:

Stopped SQL mail session.
Remarks

If there is no existing SQL Server mail session to stop, a message is returned.

Permissions

Execute permissions for xp_stopmail default to members of the db_owner fixed database role in the master database and members of the sysadmin fixed server role, but can be granted to other users. However, for security reasons, you should limit permissions for this stored procedure to members of the sysadmin fixed server role.

See Also

sp_processmail

System Stored Procedures (SQL Mail Extended Procedures)

xp_deletemail

xp_findnextmsg

xp_readmail

xp_sendmail

xp_startmail

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