ASE 12.5.4 Linux 64 Bit
I am confused about the behaviour of the following:
If my T-SQL session's transaction Isolation level is 1 - Read Committed and I start a transaction and update a table. I should be able to Select data from the same table with out being blocked.
However my select statement waits until I commit or rollback,
sp_lock show Ex_Page and Ex_intent Locks on the datatable (select * from sysobjects)
It seems to be operating at Isolation Level 3 regardless.