Find Locks on a table

We have table and we are unable to truncate,delete, or rename the table. I am getting an error message "Error 1222: Lock request time out period exceeded"

Looks like there are locks on this table but I am find and end the locks. I tried SP_who2 and other Sp_lock but did not find anything. Please advice me how to resolve this issue.
SrivAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
The lock timeout is set by your client application. So you need to run sp_who2/sp_lock (or the activity monitor in SSMS) while that application tries to execute these statements.
0
Peter KipropCommented:
The simplest solution to this is to restart the service (MSSQL service). You can also check if there could be an open transaction by executing
DBCC opentran() and if there is then kill (spid)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
How big is that table?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
You just choose the worst solution possible. Restarting SQL Server isn't a solution and can provoke another unexpected issues and it also doesn't solve your problem as it will return soon.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.