<?php

$sku = 'Your Product Sku';

$id = Mage::getModel('catalog/product')->getIdBySku($sku);

if ($id){

    echo "SKU {$sku} exists";

}

else{

    echo "SKU {$sku} does not exist";

}

?>