Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Regarding Merge Replication on Pocket Pc device
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 06/21/2005 :  06:27:21  Show Profile  Reply with Quote

Respected Sir/Mam,

I'm developing a application on Pocket Pc emulator by using Merge replication to synchronize the database.

Database synchronization works totally fine in both the directions i.e frm Pocket PC -> Local Database & vice versa.

But when i try to insert a new record, i get the error as follows...

"A duplicate value cannot be inserted into Unique index..."

when i execute the SAME query in Ms SQL it works fine....But the same query gives error in Compact Environment.

When i searched on Net, I got one solution But it also did not work w.r.t my application.

it suggested...Delete the index column and then get the snapshot of the database...

But my index are generated with respect to PRIMARY Key column and thats why Ms SQL denies to delete indexes.

Thus, I hereby request You to suggest me something which i can implement.


Mandar C Jambotkar,

Agrofoyer Solutions Pvt. Ltd.,
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000