SQL Server Error 22007

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server Error 22007

SQL Server Error 22007

Rate Topic

Display Mode

Topic Options

Author

Message

adeel.imtiaz

Posted Sunday, December 23, 2012 1:35 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 45, Visits: 175

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

MyDoggieJessie

Posted Sunday, December 23, 2012 11:24 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:19 PM
Points: 2,037, Visits: 3,761

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" Wink

Post #1399760

« Prev Topic | Next Topic »

Permissions