SQL Server Performance

Unique Identifier

Discussion in 'SQL Server 2005 Replication' started by filson, Dec 26, 2006.

  1. filson New Member

    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
  2. madhuottapalam New Member

    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
  3. dineshasanka Moderator

    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/

Share This Page