Article ID: 292237 - View products that this article applies to.
This article was previously published under Q292237
BUG #: 235435 (SHILOH_BUGS)
When you try to start SQL Mail with the default profile using xp_startmail, the following error message may be returned:
This occurs only on nondefault instances when the profile name is not specified as a parameter.
Server: Msg 18024, Level 16, State 1, Line 0
xp_startmail: failed with operating system error 2
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Specify the profile name as a parameter:
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.