Intial snapshot for Merge Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Intial snapshot for Merge Replication

Hello, 1> I’m setting up Merge Repl. I’ve about 250 tables with
Identity Column. I’ve to change properties of table with
NOT FOR REPLICATION (For Identity column) ..what is
easiest way to do this. I know you can do it thr; EM..Any
other quick way.. 2> while seeting up Intial snap shot for Merge Repl.
How should I handle Identity ranges?
Do I have to go to each table in artical and set there?
Can I do it once for all tables? How? Thanks
Check this MSDN Link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/repwizrd/repwizrd_19rn.asp] and corresponding links to follow. I think using a script from QA is better to change properties for a table. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>