No indexes or triggers on target table.

Recovery model is Simple and I've tried with recovery model of bulk-logged with no change.

I'm not sure if tempDB or the DB running the...

UNTESTED!!!!!

But at first glance, isn't this the correct syntax?

aReturnKeyPrm.Direction = ParameterDirection.Output;

This also works....

SELECT

IndicatorName, DHBName, PHOName, PracticeName,

Numerator, Denominator,

sum(Numerator) OVER (PARTITION BY IndicatorName, DHBName) as DHBnumTotal,

...

You can also add the 2000 server as a linked server on one of your 2005 databases. This would give you the ability to use the 2005 features on the...

What I was referring to is how are the emails being opened? Any report attachment that we send out will be fine if opened through the Outlook application, but if...

I'm pretty sure that the only things you need to do in the RDL files is...

- change the namespace.

- delete the entries for interactive width and interactive height.

I've had to...

In SQL 2000 it's under user defined functions. In 2005 it's under Programmability > Table-valued functions.

This is all provided that your login has execute permissions on the function. If you...

You need to define the owner during the execution.

select dbo.split(name) from table

And actually since this is a Table-valued function, you need it to be in the FROM part of the...

I believe this has been addressed in RS 2005 with the addition of the "Manage all subscriptions" option in role settings, but I'm not positive.

~~Sorry~~

Are you experiencing the problem through the web exchange interface, outlook or both?

Have you tried sending the report to a hotmail or other type of email service?

That is not an easy task at all. If you can log into the 2005 report server and then "Edit" each report's definition, then you can save those report (rdl)...

This can not be set on a per-report/subscription level. You are correct, it can only be set server level.

With Visual Studio 2005 you can step through stored procedure execution. I've not done this, but I know you can.

I read somewhere that it would be faster. I've never tested it though....

I'll have to look into that today. ----

I tested on a table with 1.5mil rows and it seems...

Change the Count(*) to Count(1)