Insert fail Data Type Error Fix??

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Disaster Recovery » Insert fail Data Type Error Fix??

Insert fail Data Type Error Fix??

Rate Topic

Display Mode

Topic Options

Author

Message

gmark 10972

Posted Wednesday, February 09, 2011 7:26 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 15, 2011 5:54 PM
Points: 5, Visits: 17

inserts are sometimes failing in one particular large table,
But reads work fine. what's a good approach for repairing the "type" data? bit of a newbie, and I have no idea how data is store in MSSQL. Separate indices? Type data? Can it be reconstructed from the data itself? Any suggestions welcome!

Post #1061663

bitbucket-25253

Posted Wednesday, February 09, 2011 7:35 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:40 PM
Points: 5,123, Visits: 20,370

In order for those who want to help you with a tested solution can you post the table definition, some sample data and what error Messages are displayed. Following the technique in the article whose link is the first link in my signature block would be of great help. Simply click on the link and follow the suggestion and code examples in the article.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1061664

« Prev Topic | Next Topic »

Permissions