Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Insert fail Data Type Error Fix?? Expand / Collapse
Posted Wednesday, February 9, 2011 7:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, February 9, 2011 7:35 PM



Group: General Forum Members
Last Login: Sunday, January 4, 2015 7:55 AM
Points: 5,333, Visits: 25,280
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.


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

Before posting a performance problem please read
Post #1061664
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse