CODEWITHSUNDEEP
t-sqlsysobjects
ninesided
ninesided

Reputation: 23263

interrogating table lock schemes in T-SQL

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 sysobjects but nothing jumped out.

Upvotes: 3

Views: 1805

Answers (2)

ninesided
ninesided

Reputation: 23263

aargh, just being an idiot:

SELECT    name, lockscheme(name)
FROM      sysobjects
WHERE     type="U"
ORDER BY  name

Upvotes: 1

SQLMenace
SQLMenace

Reputation: 135021

take a look at the syslockinfo and syslocks system tables you can also run the sp_lock proc

Upvotes: 0

Related Questions