Using SQL Server 2008, I can query
sysmail_log and other tables to see the results of sql emails.
Is anything remotely similar available for querying email logs in SQL Server 2000?
There are many reasons this feature was deprecated in favor of Database Mail. Unfortunately you need to upgrade to take advantage of better functionality.