Query to find Table schema modification who used in Replication
Hi, I have 10 tables used in Snapshot/Merge Replication. As we all knew that Tables used in replication could not able to modify schema or rename column etc. Bcos It Needs Reinitialize a Subscription otherwise it fails. Kindly refer this link for limitations of performing operations on table used in replications
http://msdn.microsoft.com/en-us/library/ms171864%28v=SQL.100%29.aspx So, How Can i identify/know which modifications are happened in table through Query??????
Your question is about snapshot replication, but the article is about merge replication. Not just merge replication, but merge replication with SQL Server Compact edition. I'd be very careful about using information you find there unless you're using Compact. Here is a [much better article] on how to make changes to the Publisher when doing merge replication. You do have to have replicate changes enabled on your merge replication in order for this to work. To see how your merge replication is configured, use: [sp_helpmergepublication 'NameOfYourPublication']; Snapshot publications are completely different and operate under other rules. :