Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jimruddy33
Starting Member
4 Posts |
 Posted - 2008-12-05 : 08:57:26
|
| Three databases that were forced restored now do nor allow manual entry, even one single characters, although using an update statement works. This is not a matter of changing the length of the datatype, but something else. For the life of mr, I can't figure out why this manual data entry egenerates the error below:"No row was updated.The data is row 2 was not committed.Error Source: >Net SqlClient Data Provider.Error Message: String or binary data would be truncated.The statement has been terminated.Correct the errors and retry or press ESC to changes the change(s).Why does this message speak about truncating when only one character is entered?Jim |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 09:12:28
|
| Please stop Updating/Inserting directly through GUI. |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-12-05 : 09:16:26
|
| May be your manual entry application is appending or prepending some characters or spaces. |
|
|
|
jimruddy33
Starting Member
4 Posts |
Posted - 2008-12-05 : 09:50:57
|
quote:
Originally posted by sodeep
Please stop Updating/Inserting directly through GUI.
Isn't there any other way to correct the situation? My developers, up until the force-restore, were able to use the GUI update freely and now they are complaining that they have to use UPDATE queries instead which takes longer. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 10:22:27
|
| Using query will be better than manual entry. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-06 : 00:57:26
|
| might be worth capturing using sql profiler the query passed down to check if correct values are being passed or any other charcters are being appended by application before sending to db |
|
|
|
|
|
|
Error: String or binary data will be truncated