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