Hi Perry,

Thanks for the reply. I dont want to manage SSRS through IIS. I want to have my report server running as it is currently internally. I just want to...

Just an update on this. I have figured out what the problem is. We are using an FTP to move the files from one location to another. Turns out the...

Thanks for this. I will use the find replace for now. I thought it may be a setting in windows or SSMS which could be changed. Hopefully the final regular...

Hi cschuck

Unfortunately we didnt get to the bottom of this one. We actually change the mdx to have less attributes which resolved the problem. I dont think this is the...

Finally it all makes sense 😀 Thanks a million for that Paul, I think we will probably try locking the source tables and wrapping it up in a single transaction....

Hi Guys

Thanks for the input again, I have run the script and no triggers exist on the database or server. When you say cached plans, could it be something related...

Hey Guys,

Good points here.. The table is a temp table starting with #.

We had come to the conclusion that it was disabling/enabling the indexes which was causing the problem but...

Hi John

Thanks for the reply,

I am using a temp table created inside a stored procedure. There should only be one instance of this sp running at a time.

Michael