if you have a small group with query analyzer access, have them shut down their analyzer windows one at a time and you'll likely see one say something about 'uncommitted transactions' on the way out. that'll force it to commit. had to do that yesterday with a db saying its in transition. couldnt run sp_who or anything. went down there and had both contractors shut down all their windows and exit management studio, problem solved.

if that doesnt work, dbcc opentran, and you can see what it's doing with sp_lock(spid). it'll probably sit there looking the same forever. kill (spid) will kill it.

still no guarantee that it's not gonna rollback for awhile if you dont know what it was doing.