Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    2

    Unanswered: Examine Locking Scheme On Tables

    Hi Everybody.

    I'd Like To Ask, How Can I Examine Massively The Lock Scheme Of My Tables. Can I Make A Query On A Systable To Do So ?

    Thanks In Advance

  2. #2
    Join Date
    Sep 2006
    Posts
    15
    Yes.

    Try this:

    select name,locking_scheme=
    case
    when sysstat2 & 8192 = 8192 or sysstat2=0 then
    'allpages lock'
    when sysstat2 & 16384 = 16384 then
    'datapages lock'
    when sysstat2 & 32768 = 32768 then
    'datarows lock'
    end
    from sysobjects where type='u'
    go

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •