Linked server query error - how do I trace it?
in [Server Configuration]
|
Prev: Help please - Repair fails "There was an error executing the Replication upgrade scripts"
Next: get number of monday, tuesday,... between 2 dates
From: Jerry Haynes on 28 Jul 2010 13:17 I have a query that runs against a linked server (tables are in dBase). When I run a simple select statement against one of the tables, I get an error: "Error converting data type DBTYPE_DBTIMESTAMP to datetime" Is there a way of tracing which record has this bad data in it? I'm running SQL SERVER 2008 R2 Thanks!
From: Erland Sommarskog on 28 Jul 2010 17:54
Jerry Haynes (JerryHaynes(a)discussions.microsoft.com) writes: > I have a query that runs against a linked server (tables are in dBase). > When I run a simple select statement against one of the tables, I get an > error: > > "Error converting data type DBTYPE_DBTIMESTAMP to datetime" > > Is there a way of tracing which record has this bad data in it? > > I'm running SQL SERVER 2008 R2 Answered in .tools. Please do not post the same question to multiple newsgroups independently. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |