Believe it or not but SQL server handles well just simple insert/update statement to insert/update text field selected from another table, at least it works like a charm with datalength...

I stopped using SQLMail completely, but use a little VBscript to notify me on seccess/failure:

Set oMsg = CreateObject("CDONTS.NewMail")

oMsg.From = "dentalxchange.com"

oMsg.To = "jpoddoubsky@dentalxchange.com"

oMsg.Subject = "Reindex failed for db on Server1"

oMsg.Body...

Hi,

I use Dynamic Property task in every DTS package and find it very easy when you have .ini file:

Sample:

1. Create .ini file

[main]

gsMailTo=jpoddoubsky@dentalxchange.com

gsLoadTo=servername.databasename

[input_files]

gsIncomingFile=D:\reports\abc.xls

gsOutgoingFolder=D:\reports_done

2. Create global variables

gsMailTo, gsLoadTo, gsIncomingFile, gsOutgoingFolder, etc...

3....

There is undocumented stored procedure available to achive you needs, I personally use it often:

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', '',  80)"

The proc will reindex everything with fullfactor =...

Here is a nice script I found a long time ago and used it many times:

delete from users_email where exists (

  select u.colid, u.email from users_email u where

  u.email = users_email.email

group by...