Robert Frasca (9/24/2010)
Sorry, my bad. What you're speaking of is if no clustered index exists. It will add one. What I'm speaking of is if a clustered key exists but isn't unique.
Then it would make sense, though where does the system store the information? As I said previously, I created a nonunique PK but wasn't able to find anything added though I KNOW that there is a requirement for a unique field in order for the replication to be able to perform it's updates and deletes on. This is just a nice to know tidbit.
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