Thank you for the replies.

There are still SQL 2005 client components on the server even though the version of the SQL instances is 2008 R2. I suspect that this...

You are correct in your sequence.

Hi there - thanks for the suggestion SSCrazy but the column is still converted to nvarchar(384).

I realize I might have missed something in my post, so let me try to clarify.

I created a view:

create view myView as

select * from Openquery([MyOracleDatabase],'select DateCol, Col1,Col2 from myOracleTable)

Eventually, I...