sybaseguru
Instructor
In order to find out which tables have row level locking in a database you can try the following:
use <DATABASE>
go
select name from sysobjects where type = 'U'
and sysstat2 & 57344 = 32768
order by name
go
Note that values sysstat2 & 57344 =0 or 8192 refer to all pages locks and 16384 is data pages locks
use <DATABASE>
go
select name from sysobjects where type = 'U'
and sysstat2 & 57344 = 32768
order by name
go
Note that values sysstat2 & 57344 =0 or 8192 refer to all pages locks and 16384 is data pages locks