There is a process that somestimes fails with the error:
Error converting data type DBTYPE_DBTIMESTAMP to datetime
This error usually happnes when you import data from another sources of data like oracle.
The weird thing is that i restart the instance in sqlserver 2000 and execute once again the procedure and it works OK.
Thr problem is i cannot restart the instance everyday because there are other procedures running, and i think this is a temporary solution. but i cannot find out the "root of the problem.". dont know if it is a sqlserver problem.
is there any better solution to tackle the problem from the root?
This a part of the code
PRO_ETL_CARGUE_PS_CATEGORIAS_CARGO_TD 2900, 511188, ''
INSERT INTO DETALLE_PS_CATEGORIAS_CARGO_TD (
FROM OPENQUERY (SCL,'SELECT
from PS_CATEGORIAS_CARGO_TD TD')
(1 row(s) affected)
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Id appreciate your help