SQL Server Performance Forum – Threads Archive

Avoiding uniqueidentifier column

Hi gurus How to avoid SQL Server from adding a "uniqueidentifier column" to the tables when the publication is created. Urgent Please Thanks raj

---

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/

---

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

---

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

---

]]>