Why I hate linked servers

time to read 1 min | 96 words

Check those out:

select

precentage_date from openquery(ORA, 'select precentage_date from PRECENTAGE')

Worked just fine.

select

precentage_date from ORA..ADMIN.PRECENTAGE

Fails with: Error converting data type DBTYPE_DBTIMESTAMP to datetime.

There isn't any values outside the range that SQL Server can handle, but still it gives me those errors. Argh!