Has developed a large integrated package under VFP using
Sql-Server as the backend. When a select statement is fired against a table
it is found the lock has escalated to table level shared, instead of releasing. The transaction mode is manual. Also tried setting the
Transaction Isolation level to Read Umcommitted. But still the escalation
takes place. Then tried by removing all the indexes existing on the table.
By doing this the problem seemed to be solved. But again after a couple of days the problem has come up again. There are no indexes at present on any of the tables. This problem has been encountered only in SQL-SERVER 2000 and
not in SQL-SERVER 7

Can anyone help me.