New Information - SQL Server 2000 SP3.
Stops a Microsoft® SQL Server™ mail client session.
Return Code Values
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 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.
System Stored Procedures (SQL Mail Extended Procedures)