SELECT gets suspended if the table contains a row lock (!)

2007-02-15 Thread Eduard M
Hi, I experience the following scenario: 1. update a row in a table (say, in one SQLStudio session, without doing commit). 2. In another session (SQLStudio or whatever), try to select * from this table. Or try to select the row that is being updated. SELECT does not return until the other session

RE: Deleted Record

2007-02-15 Thread Zabach, Elke
Hallo, unfortunately, in the log it is only written, what was done, but you will NOT see, who has done something. Therefore MaxDB cannot help afterwards. In case you have some critical tables, some triggers defined in advance could show you who did what. But without such triggers... no chance.