From Original post

" i cant install sp4 as my appli: vendor wont accept sp4"

From

<http://support.microsoft.com/?kbid=902388&gt;

"The -SupportComputedColumn parameter is a new feature that was introduced in SQL Server...

So I suggest you post your script without modifcations so we can track down where the error is.

Stored Procedures are essentially a batch of T-SQL statements that are stored in the database. There are too many advantages to list here. Have a read of this topic in...

And the answer is an astounding "It Depends".

Running the code...

The definition of Database complexity varies depending on your point of view. We have one database that has 400+ tables no stored procedures and no foreign key constraints. However, there...

Airolg Icsadjag , I think you may have over simplified the code you posted. What is permTable? What is it's structure? Where do...

Best idea would be to post the SQL you're using. Then we might be able to see where the error is.

To log a message in the Event Log you can use the RAISERROR command with a low severity, or xp_logevent.

You would need to "massage" your query result into a text...

Why can't you use integrated security? Wouldn't this address all your concerns?

"manually script the jobs and change them to use the smtp dll."

Yes, I suppose that is one way of doing it. We have an automated procedure that adds an "On...

The parameter is called @messagefile

Check http://www.sqldev.net/xp/xpsmtp.htm#Parameters

Hmmm ... last I looked there was only 1 timezone on the server.

Maybe if you explain what you're trying to achieve we could take a stab at a solution for...

Use your Dynamic Properties task to assign the passed value to a Global Variable. The use this Global Variable as an input parameter in the ExecuteSQL task.

I think I used both DTSLookups and Data Driven Query about once each.

My preferred approach is to bulk load data to a table and run stored procedures as required to...

Take a look at sp_makewebtask, with it you can generate a HTML file and then use it as the message body.