Hi I am trying to extract data using SQL Server 2005 from a table on an ODBC linked server using the following syntax:
select *
from [Server]..[Schema].[Table]
When I run the query the following message appears:
'Error converting data type DBTYPE_DBTIMESTAMP to datetime'
I know that this is because a date or dates have been incorrectly input into the source database (e.g. 200-06-01 instead of 2008-06-01)
I would like to know how to locate/isolate this date field error via an SQL query in order to correct the date field in the source database.
Any ideas?
Thanks in advance