I looked into that and didn't see any conflicting processes at the report run time. I did do some other research and found that it may be failing looking...

Thanks to both of you. I'll take a look at both suggestions and see if either of them are likely and report my findings back.

Thanks to both of you for your replies and I will look at both options.

I don't know if I was clear in my original post or not, but both instances...

Hey all, thanks for the support on this. Unfortunately I'm running SQL 2005 Standard edition so I cannot use data driven subscriptions. We've found a work around on...

I know the configuration is not optimal however it's what I have at the time. In any event, I found what I need to do to make a replica...

Thank you both for your replies I am fairly new to the DBA role and don't know all of the ins and outs of what is and isn't possible with...

I did update statistics along with the index rebuild over night and things are much better now.