Post reply

Finding Lock level of a table

  • July 22, 2008 at 12:30 pm

    #154549

    I want to be able to see what type of lock level is assigned to each of the tables in each of my databases in SQL Server 2005. Is there any command or sp's that can give me this?

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • July 22, 2008 at 1:50 pm

    #846678

    sp_lock

  • July 22, 2008 at 1:54 pm

    #846682

    sp_lock does not give me what I want. I need lock level(page level, role level, table level) of all the databases with their tables

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

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

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