Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
In merge replication if I run sp_removedbreplication will that remove rowguids or not?
Will it take into account the preserve_rowguidcol values in the sysmergearticles table?
UPDATE dbo.sysmergearticles SET preserve_rowguidcol = 1 WHERE type = 10 and name = 'MyTable'
It will preserve the rowguid column for the article.
Required, but never shown