Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    2

    Angry Unanswered: DB lock in SQL Server

    HI,

    I am new to SQL Server thing. I am facing a problem with locking in SQL Server.
    2 days back my all the DML statements were giving the timeout error. Using the Enterprise Manager I was able to find that there were 2 DB locks in the database.
    Then after a day or so I found that one of them is automatically killed, but one is still there. But this time I am able to execute DML statements.

    How this is possible. the lock was DB lock.
    This is urgent. Thanks in advance..

  2. #2
    Join Date
    Jul 2002
    Posts
    9
    Hi,
    In the enterprise manager, having admin rights, you can look at what is going on inside your SQL Server. The EM will show that the database has locks but you have to pay attention when it is blocked. In the EM under Management, refresh current activity and look at expand locks/Process ID. If you do not have (blocked) next to anything you are free to do what you need to do. Also you can open up Process info and gather more information as to who is holding the lock and the code represented.
    Adam

  3. #3
    Join Date
    Jul 2002
    Posts
    2
    Thanks

    But my problem is DB lock. As the Enterprise Manager displays that the lock on the database is DB lock then how can I execute the DML on the database. The DB lock type was shared.

Posting Permissions

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