drew.georgopulos (1/15/2013)
Second, NUTS! the requirement of a pk or unique index torpedo's my intention, as the source does not create uniqueness and attempts to create the minimum requirement, a unique index, consistently fail on the existence of duplicates.
Maybe read what I said again.
A unique index is needed if you want to enable the table for the net change function as well as the all changes function. If all you want is all changes, then the requirement for a unique index (for the net changes) falls away
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability