to check locking scheme of 1 table:

1use DBNAME
2go
1select lockscheme("table_name")
2go

or

1> use DBNAME
2> go
1> sp_help <table_name>
2> go

To check locking scheme of all user tables:

select "Table"=left(name,32),"lock_scheme"= … Read the rest