• Robert Frasca

    The uniqueifier is created when a non-unique clustered index is created. This makes the clustered index unique. Did you actually define that clustered index as the primary key, i.e. with the primary key constraint?

    I think that you are right about the 2 discussions:hehe:

    I took an existing table and set a field to be a PK, making sure that it was not unique.

    I treid to create a publication before and after.

    Just shows that there is ALWAYS something new to learn, and I think that we do daily:rolleyes:

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan