<p>Is there some means of querying the system tables to establish which tables are using what locking schemes? I took a look at the columns in <strong>sysobjects</strong> but nothing jumped out.</p>

[{'answer_id': 7935, 'author': 'SQLMenace', 'author_id': 740, 'author_profile': 'https://Stackoverflow.com/users/740', 'pm_score': 0, 'selected': False, 'text': '<p>take a look at the syslockinfo and syslocks system tables\nyou can also run the sp_lock proc</p>\n'}, {'answer_id': 7936, 'author': 'ninesided', 'author_id': 1030, 'author_profile': 'https://Stackoverflow.com/users/1030', 'pm_score': 2, 'selected': True, 'text': '<p>aargh, just being an idiot:</p>\n\n<pre><code>SELECT    name, lockscheme(name)\nFROM      sysobjects\nWHERE     type="U"\nORDER BY  name\n</code></pre>\n'}]
['https://Stackoverflow.com/questions/7933', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1030/']