• The reason I am creating a surrogate is because I need a KEY field.

    I can't use the identity because now and then records are added or removed. Using identity will not guarantee that the ID field is the same after the rebuild.