Error when attempting to change value of INT field in SQL table. Help!
Posted on 2016-08-03
I have a very strange situation. When trying to update the int value in a field, I get the error below. The strange part is that I only get the error if the original value is certain numbers. For example, in this case, I'm trying to change the value from 15 to 3, or really to any other number. It will not let me change it. If I pull up other fields with different initial values, say 3, then it changes no problem. The field is an index, but other than that, nothing special.
Any thoughts? Let me know what other info you need. Thanks!
"No row was updated.
The data in row 1 was not committed.
Error Source: .NetSqlClient Data Provider.
Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
Correct the errors and retry or press ESC to cancel the change(s)."