Problem:

Was working fine in SQL Server 2000, but now, cannot see the locks.

Resolution:

Since the SET CONCURRENCY statement is not supported by all ODBC drivers try the (WITH UPDLOCK) hint as follows:

SELECT  col1, col2  FROM MyTable WITH(UPDLOCK)WHERE (Col = 'Predicate1')

This worked in SQL Server 2005.