Hai friends I previously have one transactional replication.so my tables one uniqueidentifier previuosly also.Then I widrawn transactional and went for merge replication.Here in 2005 it created another uniqueidentifier in my tables.so I have two unique identifier in my tables.When I am creating publication can I set uniqueidentifier name ? Thanks in Advance Filson
Have u Deleted the publication created for the transactional replication. if i am not mistaken ;the uniqueidentifier column will automatically get dropped when u delete the publication. Madhu
quote:Originally posted by madhuottapalam the uniqueidentifier column will automatically get dropped when u delete the publication. No it won;t remove unique identifier column when you remove publication ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/