SQL Server Performance Forum – Threads Archive
Avoiding uniqueidentifier columnHi 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
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.