>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.

Does this mean that you set the transaction mode via VFP? Did you set it back to Automatic?

VFP implements manual transactions using SQL Server's SET IMPLICIT_TRANSACTION option. IMPLICIT_TRANSACTION starts a user defined transaction when any one of a number of commands are sent to SQL Server (refer to SET IMPLICIT_TRANSACTIONS in the BOL). When you issue SQLCOMMIT() or SQLROLLBACK(), the current transaction is terminated but IMPLICIT_TRANSACTION is still enabled and another user transaction will be started as soon as the appropriate command is sent to the server.

-Mike