Look real hard at your application. The fact that you can enter the data and it is fine directly to the database points back to the application.

Good...

That would be the correct way using the gui. you could also use t-sql command alter database 'the name of the database' collate 'collation name'

The issue you are seeing...

It strikes me that like SAN's there are a few things that are essential. Having enough cpu and memory to begin with so that you can utilize it when...

So what did your final insert into through the linkedserver look like?

Mark

There is a new book by Joy Mundy and Warren Thornthwaite of the Kimball Group, it's a pretty good treatment of Data Warehouses on Microsoft.  Wiley publishing.  'The Microsoft Data...