That doesn't seem to solve the question you asked..

CEWII

I would think it would be there without a SQL restart, but you might need to do the restart. You could also try it on a different machine to...

Thats a good catch Ian, the question I still have is whether he is getting emails when there is NOT an insert.

CEWII

I don't know, multiple fast cores.. The only thing I find exciting is the number of cores.. Speeds have largely peeked..

CEWII

This might work for you:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61987/

If not I can describe it in more detail..

CEWII

Have you identified all the objects that email yet?

CEWII

Ok, you seems to have the machanics of it worked out, what do you need me for?

CEWII

Are you looking for three passes through one process, once for each client and date? What is the output of the process?

There is a way but I need a...

What user is the SQL Server and SSRS server themselves logging into the machine as? If you open the services applet in control panel the last column is "Log...

Ok, lets see..

You have user supplied fields on a table with a known structure?

I see this as a query with lots of optional parameters, here is some code to demonstrate

IF...

I'm guessing you have another trigger out there since this one will not fire for anything BUT an insert.

How many servers are you working with?

Also, run this code in your...

I'm sorry to be blunt (or unpleasant) but I can't see one reason to do this. Can you explain why you would want to do this?

Sorry..

CEWII

1. Acquire an executable called WGET or equivalent..

2. Using xp_cmdshell execute a command using WGET to get the file.

There is no internal support for this.

CEWII

Since you are simply storing the data I don't see any issue with varchar(max). If you can parse the data out into normal columns that would be even better,...

I believe you have to have high level permissions, such as sysadmin.

CEWII