Author Archives | sunil.singh
sunil.singh - who has written 4 posts on Welcome to GlobalLogic Blogs.
Merge replication — Points to be considered
While setting up merge replication I came across different hurdles and read many articles/blogs to get around those situations. With this write up I have tried to consolidate some of the important points which can be taken care while setting up merge replication or while trouble shooting merge replication. 1. Make schema changes with sp_repladdcolumn and [...]
Continue reading...Troubleshooting merge replication — Mismatch between the replication metadata
Tuesday, January 10, 2012
Error Message: The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not having synchronized within the retention period, or because of one of the replicas being restored to a backup older [...]
Continue reading...Uncovering exciting feature of Sql Server — Change Data Capture(CDC)
Saturday, February 26, 2011
Recently we were asked to implement auditing of OLTP database and that lead us to thinking of different solution in place. We came across many solutions from triggers, timestamps and complicated queries (stored procedures) to audit data. I remember that SQL Server 2005 introduced the new features of ‘after update’, ‘after insert’ and ‘after delete’ triggers [...]
Continue reading...
Friday, April 20, 2012
0 Comments