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

682 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,130 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,130 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,546 reads

Blogs

How Long Will It Take to Learn SQL? The Truth Might Surprise You

By

In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Read the latest Blogs

Forums

Reference for doing Data Warehousing in SQL Server

By pietlinden

Everybody (well almost) knows that if you want to learn the design patterns for...

SSIS Execution Error

By Wecks

I am no SSIS expert and am struggling here I am hoping some of...

Pivot query

By Roust_m

Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers