December 23, 2012 at 1:35 am
Dear Gurus,
I am facing SQL server error in Production your valuable input is required urgently.
please see attached sheet.
Thanks
Adeel Imtiaz
December 23, 2012 at 11:24 am
The data being passed (varchar value) is too large for the datetime datatype. You haven't posted any code so its tough to tell you where that may be coming from but my guess would be either during variable assignment for a comparison in a WHERE clause somewhere (as a result from data stored in a table somewhere)
Perhaps you're storing "date" values in a table somewhere that's not actually for a column that has a varchar datatype and someone's entered some bad data, causing this error to arise.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply