And hopefully you aren't referencing an admin share - such as C$, D$. You may want to try using RunAs with SSMS or whatever you are using for the bulk...

Yes, we changed the authentication section in the RSReportServer.config back to using NTLM. And then had to change the credentials for the web site - changing the web.config file to...

Prior to Windows 2008 you had to cluster MSDTC but it was re-architected starting with Windows 2008 so that it runs locally even on a cluster. There is a blog...

When the stats are considered stale is subjective - there is no clear cut way to say they are stale. Generally you can look at how many rows were modified...

The calculation is correct. To explain it further and the documentation for such:

Pages and Extents Architecture Guide

"In SQL Server, the page size is 8-KB. This means SQL Server databases...

You need to grant permissions on the Report Server - even if using the report viewer control. The following article explains granting the permissions:

Granting Permissions on a Native Mode...

SQL Server doesn’t have statistics for table variables like histograms and density vectors.

It always estimates the number of rows as 1, though I'm not sure if this is true...

Backup compression is something else you may want to consider.

Sue

I've seen the error with clock drift. That why sometimes it can be faster to just enable Kerberos logging to find the errors and go from there. SSPI error would...

Yes, the page would break, force a new page when you set the page break between the invoice section and the terms and conditions.

Sue

Create a job with a job step in msdb database that executes the command: Exec dbo.sp_cycle_agent_errorlog

And then schedule it to run once a week.

Sue

Try a page break between invoice info and T&Cs.

Sue

That Unknown Command error seemed like it started popping up a lot on version 10. Maybe try 8.1 or whatever it was previously...I think 8.1.

Sue

Have you tried getting it to work using SSRS join? That's how I've typically passed multiple values and that's what the SSRS join is for. I haven't played with it...

Gas