Does any if this perhaps apply:

http://technet.microsoft.com/en-us/library/bb326290(v=sql.105).aspx

Specifically the section about URL addressing?

Sorry typing on a phone!

The path included in the error message:

'C:\RSScripterzip\OGS\Emailed\Weekly\...'

Does that path (and the expected files) exist on the server on which you are trying to execute the CMD file generated by RSScripter?

Not sure, starting with the obvious: does that path reported in the error exist? Seriously, cut and paste it into explorer to make sure there isn't a typo? That...

Maybe someone already pointed this out:

The question in the email defines @i as:

DECLARE @i TABLE( mychar VARCHAR(10));

The question provided on the page where you provide an answer defines @i as:

DECLARE...

If waiting for the next installment grates on you, then Erland summarized the technique of maintaining ownership chaining through certs, cert based users, and signed stored procedures:

http://www.sommarskog.se/grantperm.html

jhood-

Thanks for the followup. I got a lot of great responses to this, including the one that pointed to the fact the SSRS scripter tool was rolled up into...

Wolf-

You are exactly correct. I generally never create catch-all queries and opt for the dynamic sql implementation every time. Gail Shaw did a great write up on the...

I figured out that it is possible to use cascading filters (i.e. dependant filters) in SSRS 2005:

This is how I did it:

- Updated the SP that retrieved the Transaction IDs...

I agree, 700,000 rows in not feasible, thus why I am looking for options. Sadly SSRS 2005 is pretty limited in that regard.

The Transaction ID is one of the...

Thanks to MM for helping me out!

Thanks Pablo for your input. I was pretty certain it would be best to partition consistently across all tables. Thanks!

Yes. Further, I don't think it is possible to issue a database audit against an individual column even though the Syntax section indicates otherwise. Even if you try...