HTML Table Results For Email

HTML Table formatted results of a view or table for emailing

Disk space alert per drive

This script validates the sufficient disk space per drive.
When you'll reach a minimum on a diskdrive, the script will mail all recipients.

Use sp_send_dbmail to send multiple file attachments

Multiple file attachments with sp_send_dbmail

Sending Mail In SSIS Using Script Task- Simpler and Flexible Approach

Script Task in SSIS can provide simpler implementation of complex mail functionality in comparison to Send Mail task.

Send Query Result as HTML Mail

Send a SQL query result as HTML mail using cdosys

Send SMS from a trigger

Function to return the SQL Version Number

This function returns the SQL Build Number as an int. i.e. 7, 8, or 9. @@Version is great, but super long, and the formatting of the string has changed over the years. This helps me find out what version of SQL I'm working on in a quick and efficient manner. The script includes the drop […]

Function to return the SQL Build Number

This function returns the SQL Build Number as a nvarchar(20) string. i.e. '8.00.760' @@Version is great, but super long, and the formatting of the string has changed over the years. This helps me find out what build of SQL I'm working on in a quick and efficient manner. The script includes the drop statement as […]

MIME64 Encoder and Decoder written in T-SSQL

Here is a MIME64 encoder function written entirely in T-SQL!© 2006 Peter Larsson, Developer Workshop, all rights reservedAs long as the copyright notice is visible within the function declarationand you include a note in the documentation of your system that thesefunctions are written by me, you may use these functions for free of charge.If you […]

Get SQL code Blocking and Blocked procs + Notif

This script was created to Identify Query string that is blocked and the one that is blocking with a datetime reference. These information is stored in a history table.It also sends a mail notification without using SQL Mail