Re: Users who are current using the table
Modify one of the below scripts. This should give you the info you want...
=======
database sysmaster;
select username name, pid, dbsname[1,10] database,
tabname[1,12] table, hostname, type
from syslocks, syssessions
where
syslocks.owner = syssessions.sid
order by 3,2
=======
database sysmaster;
select username name, pid, dbsname[1,10] database,
tabname[1,12] table, type, count(*)
from syslocks, syssessions
where
syslocks.owner = syssessions.sid
group by 1, 2, 3, 4, 5
order by 6 DESC,3,2
anonymous wrote in message <74ler6$ofp@netnews.hinet.net>...
>Hi,
>Is there a way to list all of the users who are current reading/writing
> lock)
>a specific table?
>
>Thanks in advance.
>
>Handel Ju
>UMC FABII , Taiwan.
>
>