August 23, 2007 at 8:54 pm
I have a single table in my DB that has suddenly become non-updateable after functioning for several years. When I open the table directly from Enterprise Manager (SQL 2000), I can't edit any records. All the rest of the tables are unaffected.
WHen I attempt to edit a record, it simply hangs and eventually times out. Enterprise Manager becomes non-responsive and I have to close it with task manager. The problem seems to resolve for a few moments when I reboot the server, only to recur within minutes.
I've never seen anything like this and am clueless as to where to look for the problem. Could this be malware? There is a delete trigger on the table, but that has been in place unchanged several years. When I am testing the table, no application is accessing it.
Thanks for any suggestions.
Sam
August 23, 2007 at 9:35 pm
Please post the table's DDL, including constraints, indexes and triggers.
What command are you sending on the server to run the updates (application side)?
What are the error messages?
Do you have any deadlocks (sp_who2, check out the blocked by column)?
August 23, 2007 at 10:12 pm
How many records are there in the table?
"Keep Trying"
August 23, 2007 at 10:12 pm
How many records are there in the table?
"Keep Trying"
August 23, 2007 at 10:56 pm
Assuming that the account you're connected to the sql instance has got write permissions, things to check:
- does your log file have enough space to grow?
- does your trigger have a "rollback transaction" and if yes, what is it for?
- is the table into a read-write file/filegroup (check in db properties)
August 24, 2007 at 10:13 am
Thanks so much. THe problem is on the frontend afterall.
August 24, 2007 at 10:26 am
What was the problem?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply