Hi,

I run the UPDATE statement which is taking long time to complete the transaction, in th mean time, i cancelled the UPDATE query but the concurrent user/process could not access the affected table, i mean the UPDATE corresponds to that table name. Probably i think it would have acquired Exclusive lock on it and trying to block the table from accessing.

Please help me to remove the block from the table so that other process can access in a effective way.

Thanks in advance.


Thanks,
Chandra

__________________
Thanks,
Chandra

Find the block process (select * from sysprocesses where blocked=0) find the offending blocker and kill the spid. Log on to your database server --> task manager; end the PID process that correlates with the kpid in the sysprocesses.

Jaime E. Maccou