Facing the annoying situation that management studio won’t show you the tables of a database but complain about timeout the usual suspects are:  transactions. But exclusive locks – blocking (protecting) the integrity of tables – are ...read more