SQL Server Performance

how to release a lock on table...?

Discussion in 'SQL Server 2005 General DBA Questions' started by deepu_v04, Jan 29, 2008.

  1. deepu_v04 New Member

    One of the table in my database is got locked. actually it hasmany dependencies in the database. i don't know where it has get locked.

    how can i unlock the table with out restarting database or system. any help is appriciated.

  2. Luis Martin Moderator

    No way. You can run sp_who2 to find the guilty and KILL his process.
    But that is not a solution. You have to talk with developers about this problem.
  3. satya Moderator

Share This Page