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 […]

2003-11-07

1,449 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.

2002-06-06

674 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)

2002-06-03

2,097 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 […]

2002-05-16

1,081 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 […]

2001-08-09

3,524 reads

Blogs

Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)

By

Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...

CosmosDB and Consistency

By

I was doing a little work with CosmosDB recently, and there were a few...

Daily Coping 17 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Linked Server UPDATE & DELETE fails . But INSERT & SELECTs work fine

By CheBob

Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the...

Extended Events - how can I query the location of File Target of an XE Session?

By Vladimir Isaev

If I know the XE Session name, is there a query to find out...

tricky query with patterns of consecutive rows

By rotcha99

Hi! I'm having struggle with selecting rows, that match "dynamic" rules as described: if...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding Time

See possible answers