asked
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][1] 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'][2]; Snapshot publications are completely different and operate under other rules. [1]:
http://technet.microsoft.com/en-us/library/ms151870(v=sql.105).aspx [2]:
http://technet.microsoft.com/en-us/library/ms189475.aspx
I guess I don't entirely understand the question. If you're making changes to the schema, those are the changes you're making. They're the ones that are going to affect replication. Or are you only on the subscriber end and you're asking how you can tell what's coming? If that, then there's no way I know of to see that information.
First, oh my god, you're letting the developers make changes directly to production in a completely uncontrolled fashion? That's a 100% certain recipe for disaster. But, moving on. There is nothing in replication itself that will tell you that. You will have to set up some method of observing changes on the server. You can look at DDL triggers, extended events (on 2008 or better) or using a third party tool. Those are the only ways to know if someone who has DDL privileges on your server made changes. Nothing within just the replication infrastructure will tell you.
Hi Grant fritchey, i will explain the questions Suppose if we use merge replication in our environment, I am DBA, We have 5 developers make changes in Table(they dont know the which table used in replication). So In that situation if they made alter column/drop column etc in table used by replication How can I know which developer/user what changes are made in table used by replications ? Do u understand my question????
13 People are following this question.
