Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002

    Unanswered: IRL on all tables (SQL 7)

    And here's a new question for you out there

    I want to activate Insert Row Lock on all tables of my database.
    Browsing the web, i found the following command :

    sp_tableoption '%.%','Insert row lock','true'

    The trouble is that %.% doesn't work under SQL 7 (and probably beyond)

    So, how do i replace these generic characters to tell the SP to activate IRL on all tables of the database ?

  2. #2
    Join Date
    Feb 2002
    Houston, TX
    according to BOL:

    insert row lock is...
    Not supported in Microsoft® SQL Server™ 2000.
    For SQL Server version 6.5, enabled or disabled Insert Row Locking (IRL) operations on the specified table. Row-level locking is enabled by default in SQL Server version 7.0. The locking strategy of SQL Server is row locking with possible promotion to page or table locking. This option does not alter the locking behavior of SQL Server (it has no effect) and is included only for compatibility of existing scripts and procedures.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Mar 2002
    Now that you say it, i remember having read this a long time ago

    Thanks a lot.

Posting Permissions

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