Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    Taiwan
    Posts
    3

    Red face Unanswered: Least Lock Unit??

    Dear All:

    Which least unit is locked by SQL server2000?

    A column or A Row or A Table........

    Can someone help me?

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    From the Books On Line...

    RID: Row Identifier used to lock a single row within a table.
    KEY: Row lock within an index. Used to protect key ranges in serializable transactions.
    PAG: Data or index page.
    EXT: Contiguous group of eight data pages or index pages.
    TAB: Entire table, including all data and indexes.
    DB: Database.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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