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,470 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

685 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,134 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,141 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,548 reads

Blogs

How I implemented database migration on AWS using AWS DMS

By

As a Software Engineer, I would like to replicate a copy of my database...

My personal experience dockerizing a Rust Application: Deploy to AWS ECR using Github Actions

By

I have heard about many interesting things about programming in Rust and I decided...

Terraform Elastic Jobs

By

I did a couple of other posts on Elastic Jobs. But now I want...

Read the latest Blogs

Forums

The Biggest Database Professional Challenges Today

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Biggest Database Professional Challenges...

How to use Jupyter Notebook in VSCode

By Daniel Calbimonte

Comments posted to this topic are about the item How to use Jupyter Notebook...

The Last DBCC Date

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last DBCC Date

Visit the forum

Question of the Day

The Last DBCC Date

How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022?

See possible answers