Mail

Technical Article

Database File(s) Growth Notification

  • Script

This stored proc notify the user(s) if the data/log file grew. When you execute it for the first time it will get the data/log files sizes and inserts in a table. Next time when you run the script if will compare the current size with the previous files size. This script must need sqlmail configured […]

You rated this post out of 5. Change rating

2003-11-07

1,482 reads

Technical Article

Simple email with CDONTS

  • Script

Here is a strait forward script that allows you to use CDONTS to send email.  Note that the Subject, From, CC and BCC are all optional parameters.  Because it uses a fully qualified path, this procedure can live in any database on the server.  CDONTS will need to be installed on the server.

You rated this post out of 5. Change rating

2002-06-06

693 reads

Technical Article

Sending mail using CDONTS and Sql Server

  • Script

This stored procedure can be used to send mail through CDONTS and SQL Server. It resides in the Master database and accepts email addresses and subjects with a maximum of 50 characters and a body with a maximum of 500 characters. (You can increase or decrease these according to your requirements.) For this stored procedure […]

3.33 (3)

You rated this post out of 5. Change rating

2002-06-03

2,150 reads

Technical Article

SQL Mail Stop and Start

  • Script

Since SQL Mail periodically stops working and the simplefix is to stop and start it, this script does just that.It can be scheduled to run as a task as often as desiredusing an ISQL command (e.g. isql -U sa -P  -i "e:\dba\mailstopstart.sql" -o "e:\dba\mailstopstart.out")or as a stored procedure.  It has been tested on SQL 6.5 […]

You rated this post out of 5. Change rating

2002-05-16

1,149 reads

Technical Article

Email using CDONTS (via smtp)

  • Script

Here is a very basic example script for sending emails via CDONTS. This comes from the sqlmag web-site forum. Although fine, remember that it will use the local SMTP server to forward emails onto the destination user. If your servers smtp process can not reach an exchange/group-wise/other mail box on your network, then this code […]

You rated this post out of 5. Change rating

2001-08-09

3,562 reads

Blogs

Communicate to the Individual

By

I may think I'm trying to reach the crowd, but I'm really trying to...

Monday Monitor Tips: Searching Permission Changes

By

During a demo of Redgate Monitor Enterprise to a customer, they asked about how...

Generative AI vs Predictive AI | Real-World Examples & Tools You Should Know

By

What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming...

Read the latest Blogs

Forums

SSRS: An error occurred during local report processing. The definition of ...

By sgmunson

Here's the complete error: An error occurred during local report processing. The definition of...

SQL Server 2008 to SQL Server 2022

By Skybvi

Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

Visit the forum

Question of the Day

Using Heaps

When does Microsoft recommend using a heap as a table structure (no clustered index)?

See possible answers