Tag Archives: Database Mail

SQL Server Health Checks

I have been working on automating SQL Server Health checks for a while now and use this post to share my work with the community. You will find me constantly updating this post and adding more checks and Content/Scripts . … Continue reading

Posted in SQL Server, SQL Server Health Checks, T-SQL Scripts, Uncategorized | Tagged , , | Leave a comment

File attachment or query results size exceeds allowable value of 1000000 bytes

Msg 22051, Level 16, State 1, Line 0 File attachment or query results size exceeds allowable value of 1000000 bytes. Send mail task in a DTA package failed with the below error attaching a .csv file of 3MB. File attachment … Continue reading

Posted in Database Mail, SQL Server, Troubleshooting | Tagged , | Leave a comment