I have a serious problem with my SQL server 2000 that I could not pinpoint and fix.
I write an UPDATE SQL command for a specific row in a table and execute it through the SQL Query Analyser tool. Although I do NOT get any error messages, the row is NOT updated. If I go and change the row explicitly through SQL Server Enterprise, everything is OK. I tried this on two different databases; on one it works whereas not on the other. Here's an example:
WHERE owner_id=123; --I see the owner_code (equals to 5)
WHERE owner_id=123; --I get a message that my "Command executed successfully"
WHERE owner_id=123; --the owner_code does NOT change !!!!!!!!!
I have never seen such an error with ANY database. Anyone have any ideas? I tried re-indexing my table but it did not help.