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
System Stored Procedures (SQL Mail Extended Procedures)
