I have not been able to put a "GO" in the stored procedure. What verb do I use in the stored procedure to get the same result?

Thanks

If the first one is holding a transaction open, how come it works when I execute them in a query window. Below is the script that works in a...

Add a new column then populate it with the convert function

update table set newdatecol = convert(datetime,substring(olddate,1,2)+'/'+substring(olddate,3,2)+'/'+substring(olddate,5,4))

then delete old column and rename new to old.

Hope this helps.

Ed

Thanks for the help, Ed

Thanks for the help!!!

Ed

Thanks !!!!

Works great !!!

Ed

In that case use xp_sendmail. Here is a link to it's format.

http://msdn2.microsoft.com/en-us/library/ms189505.aspx

Ed

Have you thought about using sp_send_dbmail. It has lots of parameters. You have the ability to run a sql script as a parameter and attach the output as...