Magento Articles and Tips for Developers

$blockCollection = Mage::getResourceModel('cms/block_collection');
foreach($blockCollection as $block) {
    Zend_Debug::dump($block->getResource()->lookupStoreIds($block->getBlockId()));
}