• I am a fan of using Identity columns as  primary key and then if appropriate using the "natural" key as unique clustered index.  Since the promary key is what should be used as a foriegn key I don't like the idea of having that piece of data editable.  Also witha a composite key there are more fields in a join thus harming performance.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question