SQL Server Performance

Avoiding uniqueidentifier column

Discussion in 'SQL Server 2005 Replication' started by krajdba, Mar 9, 2007.

  1. krajdba New Member

    Hi gurus

    How to avoid SQL Server from adding a "uniqueidentifier column" to the tables when the publication is created.

    Urgent Please

    Thanks



    raj
    krajdba, Mar 9, 2007
    #2

  2. dineshasanka Moderator

    It has to be there for the replication.otherwise you have to change the replication type to snapshot or transactional.


    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Mar 9, 2007
    #2

  3. krajdba New Member

    I am using transaction replication. Well now how to avoid it.

    Thanks



    raj
    krajdba, Mar 9, 2007
    #2

  4. MohammedU New Member

    For transactional replication table should have PK...
    Transactional replication will not create UniqueIdentifier clumn...If one exists SQL will not use it unless it is PK.


    MohammedU.
    Moderator
    SQL-Server-Performance.com
    MohammedU, Mar 9, 2007
    #2

Share This Page