As the first suggestion: try using sp_lock and sp_who stored procedures to find out the information about the locks.

http://doc.ddart.net/mssql/sql70/sp_la-lz_2.htm

http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx

-------------

StarWind Software developer ( http://www.starwindsoftware.com )