Records Deleted on Transactional Replication
-
Donnerstag, 14. Februar 2013 09:26
Hi All,
If some records deleted in publisher on Transactional Replication, how we will come to know that partcular records deleted on publisher? I had check on Replication Monitor but not able to find that information. Kindly let me know how we will find deleted records.
Raveendra
Alle Antworten
-
Donnerstag, 14. Februar 2013 13:29 I do not think you can find what records got deleted on the publisher explicitly using replication. Ideally, you should do some kind CDC to get that information. There are ways to certain ways to figure out what records got deleted but I do not know your complete requirement. One way to do it: if you do not want to replicate delete staements, you can set the properties in the initial replication configuration and you can compare the data that exists in subscriber and not in publisher and ideally that should be the data that was deleted on the publisher. But again, with outing knowing the complete requirement it is hard to say which is best way as there is not explicit way to find all deleted rows using replication monitor
Hope it Helps!!
- Als Antwort markiert Maggie LuoMicrosoft Contingent Staff, Moderator Sonntag, 24. Februar 2013 15:15
-
Donnerstag, 14. Februar 2013 16:28Moderator As Stan points out - there is no real way to detect this. You could run sp_browsereplcmds and go looking through the entire row set (which on busy servers could be hundereds of thousands of rows), but there is no real way.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Als Antwort markiert Maggie LuoMicrosoft Contingent Staff, Moderator Sonntag, 24. Februar 2013 15:15
-
Montag, 18. Februar 2013 14:56Create a trigger for delete in publisher to track deletes. What is the actual problem you face because of deletes?
Thank you,
Karthick P.K |My blogs|My Scribbles|Twitter|My Facebook Group|
Please click the Mark as answer button and vote as helpful if this reply solves your problem
- Bearbeitet Karthick P.K - karthick krishnamurthyMicrosoft Employee Montag, 18. Februar 2013 14:56
.png)
.png)
