lck m x sql server 2008

LCK_M_IX, explanation goes here along with steps playstation 3 emulator tpb to troubleshoot.
This gave me a list of all current processes.As the title goes, this is a dirty solution so you must utilize this only if you are confident.LCK_M_RIn_NL, explanation goes here along with steps to troubleshoot.LCK_M_RIn_S, explanation goes here along with steps to troubleshoot.LCK_M_IS, explanation goes here along with steps to troubleshoot.There was only one open process on this database at the time, so it was the likely culprit.SET @objectid object_ID(N'tablename ; -look at locking in the.LCK_M_RIn_U, explanation goes here along with steps to troubleshoot.LCK_M_SIU, explanation goes here along with steps to troubleshoot.LCK_M_U, explanation goes here along with steps to troubleshoot.LCK_M_SCH_S, explanation goes here along with steps to troubleshoot.I tried to replicate this and the same thing happened also couldnt run a Select on the table.LCK_M_S, explanation goes here along with steps to troubleshoot.
And to make things worse, this was done outside of the try/catch/finally structure that ensured that any open transactions would be committed.
As Pinal Dave writes: As mentioned earlier, if you kill something important on your production server, theres a great possibility that youll face some serious integrity issues, so I theres no way I advise use this method.