Contents
Are there database mail failures in SQL Server?
Failures are not obvious to the us though, and developing a process to monitor these failures alongside other failures will save immense headaches if anything ever goes wrong. Database Mail is a component of SQL Server that is available in every edition, except for Express.
Why is my SMTP database mail not working?
If you have determined that the Database Mail is failing because the SMTP server cannot be reliably reached, you may be able to increase your successful mail delivery rate by increasing the number of times Database Mail attempts to send each message.
How can I troubleshoot a database mail problem?
The extra details can be useful when troubleshooting a server problem. For example, knowing when Database Mail starts and shuts down can be helpful when diagnosing email, network, or service problems. If anything unusual happens, it will be logged here. With details of the error message, as well as the process are logged here.
Why do I need to use database mail?
Database Mail is a convenient and easy way to send alerts, reports, or data from SQL Server. Failures are not obvious to the us though, and developing a process to monitor these failures alongside other failures will save immense headaches if anything ever goes wrong.
Is there an issue with SQL Server full text indexes?
Recently, we experienced an issue in production with SQL Server Full Text Indexes. Users complained the following query didn’t return records, even when there were records that matched the condition and the query returned records in the development and test environments: How do we resolve the issue, and make sure this doesn’t occur in the future?
Where does SQL query for replication articles run?
This needs to run on the publisher database, not the subscriber database. Displays information about an article. This stored procedure is executed at the Publisher on the publication database. For Oracle Publishers, this stored procedure is executed at the Distributor on any database.
How to fix full text search in SQL Server?
After a lot of research, we found these articles from Brent Ozar and StackExchange telling us this issue has been present since SQL Server 2008, and we discovered the possible ways to fix the full text search: Enable population schedule on the table. This was already confirmed, so not an option. Repopulate the full text catalog (update or full).