Easiest method is to delete and re-create the file.

I've come across this before. My feeling is that there is a bug in the save routine that doesn't save the Execute Package task correctly.

You can try,

a) deleting...

Checkout the scanners available over at http://www.sqlsecurity.com

Take the plunge and get rid of the MAPI dependency.

If you must use a task in DTS, instead of ActiveX Script, check out the DTS SMTP Task at http://www.sqldev.net

Take a look at the ANSI settings. If you run profiler you'll see what gets set for the connection.

Maybe something to do with your server or database settings.

When I run your query I get,

fld1        matches                 
----------- ----------- ----------- 
1           Match found Match found
2           NULL        No match fo
3          ...

It would be helpful if you provided a description of what you are trying to achieve.

On first glance I'd suggest the following,

1) Move the sub-query from the WHERE clause to...

Don't know if it's widely known but I've found that if you have the report showing in Report Manager when you deploy the report it seems to keep displaying the...

I was thinking about that after I posted the code. Surely it could be done without the flow control. Some sort of logic involving the datepart value maybe ????

I don't think you're using SQL Server  2003 as there hasn't been a new version since SQL Server  2000 and SQL Server  2005 hasn't been released yet

Hmmm ... something that simple ...

Can't reproduce it on my servers, must be something in you environment.

CREATE TABLE #tm (

    to_time datetime

)

INSERT INTO #tm VALUES ('1 Nov 2005...

Try this page located via a quick Google search,

http://sqldev.net/misc/WaitTypes.htm

If you can provide the table definition and the query you're using it would be most helpful

Try this

SET DATEFIRST 1

DECLARE @DATE datetime
DECLARE @EOM datetime
DECLARE @SAT datetime

-- set a date to use
SET @DATE = '15 Jul 2005'
-- add a month 
SET...

Brenda

xp_smtp_sendmail has a parameter called @MessageFile, You just pass in the full path and filename to the html file and it is used as the message body. There is quite...