Table Locking

[sats123]

I have a table having 40,000 records in subscriber. This table is
populated from 23 publishers. During end of day txn., one day records
are deleted from this table on publisher and these deletes are
replicated to the subscriber. The problem is repl-distributor puts locks
on this table when delete command is being replicated and other user
trying to access this table is being blocked by repl-distributor. Even
thought only 200-300 records deleted. The Where clause column in delete
command does not have index on it.
Publisher is SQL 6.5 Post Service pack 5a
Subscriber is SQL 7.0 service pack 3.

 

[RickCole]

If there is no index on your column in the where clause then your query will scan the whole table and therefore put a table lock on.

Try putting an index on the column and see if this cures the problem.

Rick.