Did you ever get a response from InterSystems on this? I get the same error occasionally and would like to resolve it if I can.

Visual Studio now has some great tools where you can build a database. It will treat it more like "code" and also you can run the project through an...

Is the table a heap or does it have a clustered index?

Dave, what other ways did you find? Others might want to know more possible solutions to solve their problems as well.

I've used synonyms for linked servers with great success. I'd recommend that.

Well, it is perfectly logical that it doesn't return a leading 0.   The Datepart returns an Integer value.   Integers are usually not expressed with leading 0s!  Which is why the...

Have you tried the NoLock hint on the query?

You could implement a trigger that would just rollback any sort of changes. 

But to be sure I would suggest keeping a pristine copy of the data offline (Maybe in...

Would adding the "Everyone" NT Group do what you want it to do?

You could have a list of the columns that you would like to sort on and then write an expression in the sort section of the report.

You could try to put a filter on the dataset where that value is > 0

That would probably be the easiest solution.

Thanks

Scott

MNS, You could create an Excel application object in a VB script task before you export the database and modify your connections and files before you begin the datapump. 

Is...