Mail

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,439 reads

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

667 reads

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,073 reads

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,009 reads

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,501 reads

Blogs

Comparing Execution Plans

By

When you run a query twice, and get dramatically different run times, your first...

What permissions do temp stored procedures use?

By

In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned...

Default resource limits for Windows vs Linux containers in Docker Desktop

By

Docker Desktop is a great product imho. The ability to run Windows and Linux...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Split values after semi colon to rows

By PSB

Hi, I need to split column values after ; to new rows . However...

Determine if DB name has numerics

By MothInTheMachine

I am writing a script to move through specific databases in our server and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers