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 |
|
itrmat
Starting Member
3 Posts |
 Posted - 2009-07-02 : 20:44:01
|
| Hi,Occasionally a record or group of records become unchangable within our SQL database. Using Management Studio and changing just a single field, eg adding a character to description causes the errorNo Row Was UpdatedThe data in row 539 was not committedError Source: .Net SqlClient data ProviderError Message: Time Out Expired...blah statement terminatedCorrect the errors and retry or press escapeRebooting seems to fix this problem but I need to find the cause or a way to fix it without the reboot |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-07-06 : 19:07:39
|
| I would suspect that there is some other problem going on at the same time with the server. What does the SQL Server Log show leading up to the time when you attempted the update?--------------------------------------------Brand yourself at EmeraldCityDomains.com |
 |
|
|
itrmat
Starting Member
3 Posts |
Posted - 2009-07-13 : 20:42:30
|
| Thanks for the reply.Nothing recorded when I trry and update the record. I have taken a look back thru it and the only thing I can see that maybe looks sus is this..2009-07-14 00:01:02.03 spid16s This instance of SQL Server has been using a process ID of 1912 since 7/3/2009 2:39:11 PM (local) 7/3/2009 4:39:11 AM (UTC). This is an informational message only; no user action is required.(I'm checking logs under Management --> SQL Server LogsI'm checking the logs under |
|
|
|
itrmat
Starting Member
3 Posts |
Posted - 2009-07-14 : 02:04:32
|
| OK.. made some progress. The problem is caused by a process that once killed fixes the issue. The process tells me that it is a view that I have created in the database. I am using an Access 2007 _Pass thru query to access this view. It seems to work fine most of the time but occasionally locks. Is there something I can do to prevent this problem |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-07-14 : 05:31:23
|
quote:
Originally posted by itrmat
OK.. made some progress. The problem is caused by a process that once killed fixes the issue. The process tells me that it is a view that I have created in the database. I am using an Access 2007 _Pass thru query to access this view. It seems to work fine most of the time but occasionally locks. Is there something I can do to prevent this problem
you can use sysprocesses and sp_lock to find out the objects that have been blocked.... |
|
|
|
|
|
|
Time Outs when changing a single field?