Welcome to MSDN Blogs Sign in | Join | Help

April 2007 - Posts

Wednesday, April 18, 2007 9:31 PM

HOWTO: Pending Changes for a Merge Subscription (Client Side)

Often there will be need to find out if there are any pending changes on client side to upload. Note that, It is always better to avoid empty sync both from the resource (network bandwidth, web server, SQL Server) usage and performance. This blog post
Posted by SQLCEBLOG | 2 Comments
Filed under:
Wednesday, April 18, 2007 9:11 PM

Merge Replication System Tables

The earlier blog post “ How to: Detect the database is mere replicated ”, gave a list of the system tables that get created in a merge subscription database. This blog post explains brief description of each of the system tables. There is another blog
Posted by SQLCEBLOG | 1 Comments
Filed under:
Friday, April 13, 2007 10:13 AM

SET IDENTITY_INSERT <Table Name> ON/OFF

This command is from SQL Server. This command is to enable the users to set their own value for IDENTITY Column in case they want to. This has been the very useful for us. We use it in MERGE and RDA when we send the client side inserts to server where
Posted by SQLCEBLOG | 1 Comments
Filed under:
 
Page view tracker