1. deepu_v04 New Member

   hi,
   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.
   
   
   thanks
   

   deepu_v04, Jan 29, 2008

   #2
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.
   

   Luis Martin, Jan 29, 2008

   #3
3. satya Moderator

   You are asking solution for an open queston, it is hard to state unless we see a code or reasons behind such locking - http://sqlserver-qa.net/blogs/tools...rrency-locking-with-asp-net-applications.aspx and http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx locking tips & http://www.sql-server-performance.com/articles/audit/index_locking_options_p1.aspx if during indexing.
   

   satya, Jan 30, 2008

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in