Hi

Thanks for your replies. Every day is a school day!

I have been using the missing index functionality as a starting point and then doing some more digging to see if...

Thanks for replying, I think you are right , small batches may well be the way forward.

Has anyone got any suggestions?

pretty please

I came accross this link yesterday when I was looking for a solution to running out of vitual memory when using import column transformation. I think it may...

okay I was begining to suspect as much, thank you for replying.

Thank you for your response. You make some very valid points.

The aim of the clean-up is to reduce the request of new reports by orgainising what...

Hi

Yes we have the source all backed up. I have tried re-deploying reports but to no avail. Interestingly though, scheduled report subscriptions still work which leads me...

I've found a solution on a previous post

http://www.sqlservercentral.com/Forums/Topic957724-1063-1.aspx