Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Error 22007 Expand / Collapse
Author
Message
Posted Sunday, December 23, 2012 1:35 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 21, 2014 4:10 AM
Points: 67, Visits: 255
Dear Gurus,

I am facing SQL server error in Production your valuable input is required urgently.

please see attached sheet.

Thanks
Adeel Imtiaz


  Post Attachments 
error1.jpg (9 views, 9.56 KB)
Post #1399739
Posted Sunday, December 23, 2012 11:24 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
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; They'll drag you down to their level and beat you with experience"
Post #1399760
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse