中没有行MSDB.dbo.sysmail\u faileditems

select OBJECT_DEFINITION(OBJECT_id('sysmail_faileditems')) 
AS [processing-instruction(x)] FOR XML PATH('')

sysmail_faileditems 定义是

SELECT * FROM msdb.dbo.sysmail_allitems WHERE sent_status = 'failed'

看着 sysmail_allitems . 它的定义是

SELECT ...
FROM msdb.dbo.sysmail_mailitems
WHERE (send_request_user = SUSER_SNAME()) 
      OR (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1)

你可能看错了表格的版本。可以在不同的用户名下创建表。所以呢数据库.dbo.mytable不同于数据库.klowrey.mytable.