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