This is very helpful for a similar issue I am facing with a database randomly going into single user mode but doesn't seem to work for SQL Server 2000.

Would you...

I am running Windows Server 2016 Standard and SQL Server 2016 Enterprise
I was not an admin on the windows server before but have just added myself now to both windows...

Hi Sue,
First query returns a value of 1, for is_broker_enabled.
Second query returns a value of STARTED for status.
Test e-mail returns additional records to the sysmail_allitems view but...

I was sysadmin on the SQL Server and changed myself to sysadmin on the Server itself also.
I retried again after I changed myself to sysadmin on the server itself,...

Hi Sue,

Here are my findings.

Right clicking on view logs under database mail pulls back 0 records.

When I run
select * from [msdb].[dbo].[sysmail_event_log]
or 

Hi Sue,

That is good to know about the SQL Server Agent History, but do you have any additional suggestions as to why e-mails are not going through?
Test...

Hi Sue,
I was able to enable the database profile and it shows up under the SQL Server Agent Properties as checked now.  The test button however is still grayed out.
Other...

We use an Active Directory account called SQLBI, The SQL Server Service is set to this account.  When I log into the SQL Server using this account I can see the...