Stops a Microsoft® SQL Server™ mail client session.
xp_stopmail
0 (success) or 1 (failure)
xp_stopmail returns this message:
Stopped SQL mail session.
If there is no existing SQL Server mail session to stop, a message is returned.
Execute permissions for xp_stopmail default to the members of the sysadmin fixed server role but can be granted to other users.
| sp_processmail | xp_sendmail |
| xp_deletemail | xp_startmail |
| xp_findnextmsg | System Stored Procedures (SQL Mail Extended Procedures) |
| xp_readmail |