Ahmed

Unfortunately the windows 2003 web edition doesn't allow sql server to be installed. It's specifically designed for web hosring.

Please see

http://www.microsoft.com/windowsserver2003/evaluation/overview/web.mspx

Tony

StefanJ

You may find the attached useful by sending email as HTML.

VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to Your Users

http://msdn.microsoft.com/msdnmag/issues/02/08/VBScriptandSQLServer2000/default.aspx

Tony

Freddy

Recently posted on Miceosoft site

A new white paper on how to troubleshoot Delegation Scenarios is

available at

http://www.microsoft.com/downloads/details.aspx?FamilyID=99b0f94f-e28a-4726-bffe-2f64ae2f59a2&displaylang=en

While this document concentrates on troubleshooting all delegation

scenarios,...

Freddy

The following might also help

Knowledge Base Article - 319723

INF: SQL Server 2000 Kerberos support including SQL Server virtual servers on server clusters

Knowledge Base Article - 326985

HOW...

Freedy

You might want to lookup Security Account Delegation..

Tony

Try XPSMTP provides a SMTP based SQL Mail solution for sending MIME based email over SMTP, implemented as an Extended Stored Procedure

http://sqldev.net/xp/xpsmtp.htm

Have a look at the following link

http://msdn.microsoft.com/msdnmag/issues/02/08/VBScriptandSQLServer2000/default.aspx

about using vbscript within DTS to generate and email HTML reports

Edited by - maudapa on 10/14/2003 10:06:27 AM

Andy

Yes but in our case we have an idea what should be the result of the job so we can test for it and take the necessary action.

In fact...

We get around the problem by using linked servers and then executing

EXEC servername.msdb.dbo.sp_start_job @job_name = 'finance_cube_2002'.

This allows the control to be kept within the steps of the job using...