I second the call to use xp_smtp_sendmail. since implementing at our site we've had no problems at all.

We've got something along the lines of what Steve is suggesting. However, the stored proc that does this renames the log file so it doesn't get automatically removed.

Hmmm ... not up to speed on the changes between Outlook 2000 and Outlook 2002. Would it be likely that Outlook 2002 handles HTML email differently?

As the article is over two years old and the author has not been active on the website since posting the article, I'd say the download is no longer available.

Hmmm ... could you use a workflow script in the ActiveXScript task that you want to run last. Have it loop around checking the execution status of the other steps....

You can use it in the ActiveXScript task. The syntax is just like I've illustrated in my post above. With the WriteTaskRecord method, if the number passed as the first...

Are you able to upgrade to Outlook 2002?

I did a google search and found a similar problem where MS support suggested the upgrade and it fixed the problems.

What version of Outlook are you using?

If pricing is not an issue, go for ER\Studio from Embarcadero. Very functional, very quick.

If the exchange server was becomes unavailable, SQL Mail has a tendencyto get "stuck". Usually restarting the service fixes the problem, but sometimes you need to reboot the whole server.

Not sure if this is "standard" practice, but it works for me. I have a little SQL database with about 10 tables and a dozen or so views.

When I...

If p_employer_id int is supposed to be your parameter, then yes it's possible although you dont have the syntax right. It should be something like,

DECLARE c_get_contact_id CURSOR LOCAL FOR...

You should also take a look at

ApexSQL Edit from ApexSQL http://www.apexsql.com/apex_sql_edit.htm

SQL IDE from Imceda http://www.imceda.com/SQL_IDE_Description.htm

SQL Source Control 2003 from Skilled Software http://www.skilledsoftware.com/sqlsourcecontrol.htm

And if you've got a...

Those options can be changed using the sp_configure stored procedure. Check Books Online for full syntax and server restart requirements.

What sort of properties are you looking to change?