Got this error today from one of my databases I'm working on. Last night I added an index to one of my tables not realizing that it may result to slow inserts. Well, as my SSIS package ran early in the morning, it's taking time for it to finish. So I had to resort to brute force to stop it. Problem is when I did that, lock for that particular table wasn't automatically released, so how do I release it? Here's how...
-- find out dbid of database
-- try each of the dbids to find out
-- in this case '9' is the dbid of my database
-- look for the 'TAB' (table) type
-- then kill that process
-- to find the table, try ObjId's
-- now kill