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.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]