Thanks!

I have done this before using the msdb tables.

you might want to try SELECT * FROM sysmail_sentitems.

I am looking at the acitvity monitor...recent queries...plan count...I am assuming its the number of plans cached...can someone confirm?...

It is a query that is running not a store proc, but runs very often.....The table does have a clustered index, but the search is done on a non-clustered...

Another method I have used is saving the report as a subscription which creates an agent jobs. you can either run that agent job after that or copy the data...

Hi Gail,

It was set at 2048mb, but anyways did a fresh install of the win 7 OS/sql2008r2 with the updates and patches last night. now it listens....

the issue here is..........i have set it at max 2gb for sql server, so why is it still holding more memory? I unserstand thats by design that it holds memory,...

This only happens when I run sql server. Again its a fresh install and I have nothing else installed and or any other process running. I just did few...

Hi David,

Thx for the reply..I have sql server memory max to 2.0gb...the box use AWE to allocate memory is also unchecked.

I had the same problem, gave the user the access to where the ssrs is installed as an admin(on the machine) and it worked fine.

if you run the script as it is, it will fail because a GO is requried.

Secondly, I just ran this in a new database, and when creating the proc's separately...