I'm making some test of the Sql Ce Merge replication. The goal is to
transfer a "per user" partition to devices.
To problem I describe here occurs with Sql 2005 and Sql Mobile, but some old
test showed that it occurs with Sql 2000 too and Sql Ce 2.0.

Does anyone know whether a 32-bit bookmark value for a particular row
in an SQL Server Mobile 2005 database row is unique >>across all
tables<<? In other words, is it possible for a 32-bit bookmark value to
repeat in two different tables?

i am using a combination of  PULL and SubmitSql to synchronize data between
PPC and back-end Server.
I save the INSERT/UPDATE  clauses in the PPC  to send with SubmitSql later.
Clients use GPRS. I am thinking to send the SQL scripts partially. it seems

http://www.pocketpcdn.com/articles/articles.php?&atb.set(a_id)=6555&atb.set(c_id
)=74&atb.perform(details)=&

We have a subset filterclause for a specific table reading
'cast(iEmployee AS nvarchar) = HOST_NAME()'
For some reason the records in this table are staying on the device and not
being removed when they are deleted from the table and the user

I'm trying to open a SqlCe 2.0 database using SqlServer 2005 but I get the
following error:
TITLE: Connect to Server
------------------------------

I have a simple Pocket PC app written in C++ on eVC that has a stand
alone database under SQL Server CE 2.0 accessed via OLE DB.
In some cases the DBs are being corrupted (still unknown cause) and I
am manually repairing them with ISSCECompact->Compact successfully.

is there  a way to insert or update an identity column
in sql server ce?
thanks.
Yener

I'm working on a device application right now, and i have the following
error message when I try to create an instance of the SqlCeEngine.
----
An unhandled exception of type 'System.MissingMethodException' occurred

I ve created a publication of a database of my SQL Server and now with
the
SqlCeReplication object I can syncronize my SQL CE database with the
SQL Server Database.

Hi... Need some help!!
  My problem is thus - I am looking for a synchronization technique
(between SQLCE and SQL Server 2000) for a PPC which can not connect to the
internet. I am not sure at this stage if the device would even be equipped

I have an application that uses SQL CE 2.0 and I was looking forward to
getting it working on SQL Mobile because of the performance increases
that it was supposed to bring. Unfortunately while it seems faster for
some operations, it is choking on a specific query that we use, where

I am using SQL Server CE 2.0 and I am synchronizing data with an SQL Server
2000 via RDA. On the server side, I have a table with 8 columns but I am
only pulling down 6 of them (two columns are of type 'uniqueidentifier' ,
two columns are 'datetime' and two are 'int') I pulled down ...

Is it the same as Server 2005, i.e. if my app does not do replication I
can use it for free? If so, where do I get the developer redistributable
edition from? The .cab files, of course, are part of the MS VS .NET 2003
but they are not mentioned in its Redist.txt so using them in ...

I'm trying to insert a DateTime into a SQL Server mobile table and it seems
to only have seconds accuracy.
I need milliseconds accuracy and after searching the web for a few hours, I
am at a complete loss how to insert the DateTime down to milliseconds