Send Email to recipients with Attachment using PowerShell
If you have a requirement to send email to recipients with attachment, can use the script.
2019-05-03 (first published: 2016-05-17)
2,937 reads
Email SP Results
Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.
2016-12-05 (first published: 2015-05-29)
2,741 reads
Backup history details EMAIL (past 24 hours) in HTML format
Get backup status email daily to your inbox in HTML format.
2013-03-27 (first published: 2013-03-14)
1,795 reads
Introducing Boomerang - A Notification Framework
Boomerang is a notification framework for IT professionals providing service oriented infrastructure with a SQL based rapid development interface.
2013-01-10
2,318 reads
SQL Start up Script
This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.
2012-09-25 (first published: 2012-08-29)
1,845 reads
Fix SSRS Subscription Owners
Stored procedure to update SSRS Subscription owners to avoid email errors.
2012-03-13 (first published: 2012-02-28)
1,165 reads
Setting Up Email Notification for SSIS Package Failure
As a DBA, we often setup monitoring to receive job failure notification, but when it comes to SSIS packages, we either do not capture the job failure (if the job runs through the command prompt) or we have no idea why it failed. In this article, I'd like to walk you through how to enable the logging functionality for SQL Server Integration Services (SSIS) and how to capture detailed information for immediate troubleshooting without "re-run" the package.
2012-01-18
2,927 reads
2019-04-15 (first published: 2009-11-18)
1,965 reads
Sending SMTP email from SQL Server using CDO
If you would like to send email from SQL Server, use this CDO method and store proceudre.
2009-08-13 (first published: 2009-07-29)
3,456 reads
Script to send an email based on contents of a job step's output file
Use to check for a string value in a job steps output file. If that string exists, send an email with the output file attached.
2013-05-09 (first published: 2008-09-04)
4,504 reads
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers