April, 2007

Posts

| |

|

Microsoft's Embedded Database - SQL Server Compact - Team Blog

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

Posted over 5 years ago

by SQL CE Team
- 2 Comments
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...
Microsoft's Embedded Database - SQL Server Compact - Team Blog

Merge Replication System Tables

Posted over 5 years ago

by SQL CE Team
- 1 Comments
The earlier blog post “ How to: Detect the database is merge 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...
Microsoft's Embedded Database - SQL Server Compact - Team Blog

SET IDENTITY_INSERT <Table Name> ON/OFF

Posted over 5 years ago

by SQL CE Team
- 1 Comments
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...