<div>
Where are you making the edit ?<br />
Can you run an update statement sucessfully ?<br />
Are there any triggers attached to the table ?<br />
Is referential integrity involved ?<br />
<br />
If you restore the db to another server so you get the same problem ?<br />
<br />
Is this a production system ?
</div>


<div>
I'm attempting to the make the edit in a View. &nbsp;I did just notice that I CAN change the values when editing the table directly (Edit top 200 rows). &nbsp;The problem seems to revolve around updating it when queried.<br />
<br />
I can not run an update query successfully. &nbsp;It just hangs.<br />
<br />
No triggers.<br />
<br />
No referential integrity.<br />
<br />
I did not restore to another server yet.<br />
<br />
This is a production system and just started happening.
</div>


<div>
Can you script the table out and paste the result so we can see the layout of the columns?<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w32/1109971/sqlTable.png" target="_blank" class="file-inline" title="sqlTable.png (39 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>sqlTable.png</a>
</div>


sqlTable.png

<div>
can u drop the index and try your update.<br />
<br />
I would drop the view and recreate it ir create another with same definition and try ur edit.<br />
<br />
If you run the update what error do you get ?<br />
Is there a primary key defined ?
</div>


<div>
Since this is a production server, would dropping the index while live create any adverse issues?
</div>


<div>
Here is the table config. &nbsp;DEAL_STSID is the field at issue.<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w32/1109973/table.txt" target="_blank" class="file-inline" title="Table config (880 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>table.txt</a>
</div>


table.txt

<div>
If you can edit the table directly then the problem is with the view.<br />
<br />
Can u post the definition ?<br />
<br />
Are you sure the row is not locked by another process.
</div>


<div>
It's multiple rows with the issue, but how can I tell if a row is locked or not?
</div>


<div>
And also, I can change the value of other fields in the row, so it's probably not locked. &nbsp;Here's the view:<br />
<br />
SELECT &nbsp; &nbsp; DEALID, DEAL_STSID<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; dbo.DMS_DEALS<br />
WHERE &nbsp; &nbsp; (DEALID = 240364)
</div>


<div>
If you run<br />
<br />
update dbo.DMS_DEALS set DEAL_STSID =1<br />
WHERE &nbsp; &nbsp; (DEALID = 240364)<br />
go<br />
update dbo.DMS_DEALS set DEAL_STSID =2<br />
WHERE &nbsp; &nbsp; (DEALID = 240364)<br />
go<br />
update dbo.DMS_DEALS set DEAL_STSID =3<br />
WHERE &nbsp; &nbsp; (DEALID = 240364)<br />
go<br />
<br />
what happens ?<br />
<br />
you can run sp_lock to view current locking info.<br />
<br />
are you logging in as the sa?
</div>


<div>
Is the error only related to record 240364 ?
</div>


<div>
Were you able to confirm that there are no other processes interacting with the record when you try to edit ?
</div>


<div>
So, the records suddenly became editable again. &nbsp;I can only assume this had to do with locking. &nbsp;I just ran into another issue where there no record updates were being allowed. &nbsp;I'm not a SQL expert by any stretch. &nbsp;How can I determine what is happening with regards to locking with the database?
</div>


<div>
In this latest episode, I stopped SQL server and started it again to fix the problem.
</div>


<div>
You can use sp_who and sp_who2 along with sp_lock as a staring point.
</div>


<div>
I feel I was on the right track with this.<br />
<br />
No worries if you dont\cant award any points in my favor.<br />
<br />
Cheers,<br />
Datrias
</div>


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


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!

Error:

"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)."

Error when attempting to change value of INT field in SQL table.  Help!

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.