April 3, 2009 at 8:42 am
Dear All
One of the frequently used table in project for lookup ( DimCustomer ) has locked somehow. Now whatever the packages using this table are getting hanged for indefinite time. I got resolution that table has been locked. How can I unlock this table now ? . I need to make changes in all select statements using this table with NOLOCK. Is there any alternative ?
Please Help ...
April 3, 2009 at 9:35 pm
Your DBA should be able to help you find out what process has locked the table ... then you just need to decide what to do about it. Killing the process is one option that will work ... 🙂
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 6, 2009 at 8:05 am
It's possible that you may be missing an index on that table so an action is taking a table lock instead of lower level lock.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply