• select count(*) as blocked_actions

    from master..sysprocesses

    where blocked <> 0

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **