Post reply

Row level locking

  • March 5, 2013 at 9:32 am

    #290385

    How to find row level locking is enabled or disabled for the tables?

    Thanks

  • March 5, 2013 at 9:36 am

    #1593535

    The allow_row_locks column in sys.indexes for the clustered index.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 5, 2013 at 9:55 am

    #1593542

    Do you know any chance in sybase database to look for row level locking?

    Thanks

  • March 5, 2013 at 10:16 am

    #1593556

    This is a Microsoft SQL Server forum, if you have Sybase questions I'm sure that you'll get better answers on a Sybase forum.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply