Sorry wrong question

SSRS 2008 R2 you can now label the tabs in excel.

Here is a link to see how.

http://www.bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports

😀

We found the Reason for the issues.

The preview tab does not use the dot net CAS  (Code Access Security).

But if you do the local debug or any other reporting...

I am using a sql shared datasource.

I had an issue like this but it was not reporting services causing the problem. It was the execution plan when it was a store procedure vs as a query...

One thing which has helped in doing some things like this for us is using a temp table or table var depending on the size of the data.

This way...

Although I am not currently doing replication in 2005. I have never had a problem changing or updating an index on replicated tables.

We looked at doing a server side trace which worked. We decided for time and effort that it was better to purchased DB Audit. It does a server side trace but...

select

substring(convert(char(10),getdate(),101),1,