Unanswered: Syntex Error converting datetime from character string
WE ARE USING SQL SERVER7.0 WITH BASE PACK , SINCE YESTERDAY I M GETTING " SQL ERROR 241 : SYNTEX ERROR CONVERTING DATETIME FROM CHARACTER STRING" I HAVE TRIED WITH SP4 , BUT NOW IM GETTING " TIMED OUT ERROR IN MY APPLICATION" ANY SOLUTION
Originally posted by cvandemaele
Can you give us MUCH more details about the statement that is failing ?
Well when we are updating any row in a some tables , we are getting the error msg , we have checked on the microsoft site , according to them there is some problem with the base pack and the problem is resolved in the sp3 or later. we have had applied the SP4 alsobut the problem is same.