Mohit (3/5/2009)
Luckily I haven't ran into replication much. Because as the only technology seems to be the defacto where I work is clustering or nothing heh. But for replication issues; I would think Identity column causes issues in Merge replications correct? Because seed values might be different in two different nodes?But aside from that in stand alone databases, mirroring, etc. Is there anywhere you guys have found Identity column to be a bad choice? Thanks.
Sure a cluster is always a good solution, but it is cost factor. We additionally have an external desaster-recovery data-center at another location. I think here is no other way than a replication.