SQL Server 2000 error sending mail via linked server

Case Environment:

Server A system: Windows Server 2000

Database version: Microsoft SQL Server 2000-8.00.2282 (Intel X86)

Server B System: Windows Server 2003

Database version: Microsoft SQL Server 2005-9.00.5000.00 (Intel X86)

The developer wants to link to Server B via the linked server on Server A, performing exec [LinkedServer]. [Msdb].dbo.sp_send_dbmail

The following two questions were encountered:

1: The following error message is reported when executing the SQL statement

exec [LinkedServer]. [Msdb].dbo.sp_send_dbmail

@profile_name = ' xxxx ',

@recipients = '[email protected]',
@copy_recipients = '[email protected]',
@blind_copy_recipients = '[email protected]',
[email protected] [Email Protected]_string2,
@query_result_width = 300,
@subject = ' xxxxx '

Msg 15404, Level 16, State 10, line 1th

Could not obtain information about Windows NT group/user ' xxxx ', error code 0xffff0002.

Where the error message inside the account is linked to the account used by the server, this error occurs because the mail configuration, the corresponding configuration file name (Profile_name) properties are not public. So this error occurs.

2: After solving the first problem, immediately after the issue 2, execute the above SQL statement, the message was sent successfully. However, the following error message appears:

Msg 0, Level 11, state 0, line No. 0

A critical error has occurred with the current command. Any results that may result should be discarded.

And then it can't be solved, but I tested OK,SQL Server 2008 with SQL Server 2008 on both SQL Server 2005 and SQL Server 2008 is OK. It seems that the problem is still on the SQL Server 2000 Server itself. The specific reason is not very clear.

SQL Server 2000 error sending mail via linked server