In the previous versions of SQLCe it was a wise move to regularly compact the
database.
However I have read something that makes me ask the question is this still
necessary.

We have finish our application using sqlce replication and everything
is working perfect except the occasion that we are trying to replicate
through gprs connection and there are upload data to be send to the
sqlserver 2000, in this case the connection ends with error 28037.

Here is the scenario under which I am getting this error on the server.
Code currently getting executed on the server tries to open a SQL CE
database (previously created with only password protection) for populating
the data and I see the error mentioned in the subject heading.

Using SQL Server 2000, when choosing the "Microsoft SQL Server Additive Conflict
Resolver" resolver using the sp_addmergearticle, I get the following error:
"The resolver information should be specified while using the 'Microsoft
SQL Server Additive Conflict Resolver' resolver."

During merge replication, I am getting the error "The buffer pool is too
small or there are too many open cursors. Minor Err: 25101, Error Code:
80004005"
Any ideas?

With SQL Server 2000 SP3, a "patch" is required to install Sql Server Ce
Agent.
What about SP4 ?
Is this "patch" available or does the SP3 version work ?

I am supporting a WinCE 4.2 operating system and need to provide SQL database
features.  This platform will now have to provide SQL database functionality
into our WinCE 4.2 target system.  
We need to be able to include the SQL components in the NK.bin file that is

i have a query which run successfully on SQL Server but giving error in
SQLCE.
The Query is:
SELECT a.Ad_Surr_Key, a.Ad_Description, count(*) as WO_Count,

I know Windows CE 5.0 has achieved FIPS 140-2 via the Windows CE
Enhanced Cryptographic Provider 5.01.01603.
Did SQL Mobile switch to using AES for strong db encryption, or does it
still use RSA4?

Hello Ng!
which code i have to use to count the various elements in my column
my Table ( col1, col2 )
[ 1 , 1 ]

I have SQL 2005 installed on a Windows 2003 server.  I have installed Backup
Exec 10d and get an error when trying to backup the SQL database.  When I go
to create a new backup job I can see the two databases ( one for Backup Exec
and the other one for Solid Edge Insight Server and ...

how can i increase SqlCE 2.0 performans? for better select or insert exc.
operation

Hi,  I was very excited when I heard of SQL Server Express and SQL 2005
Mobile.  I wanted a straightforward database solution that would ideally let
me program to it exactly the way I do with my SQL Server installations for my
web apps.  Voila!  SQL Server Express seems perfect.  ...

can anybody tell me y this doesn't work using SQL Mobile 2005
DELETE FROM mytbl WHERE Status = 3 AND myDate < #5/18/06#
thankx

I have an table that I have pulled in as XML and saved to a file on a PDA.
I want to get it into an S.SDF file.
I have been able to get it into an untyped dataset.
Is there a way to save it to a blank CE database (.SDF) without interogating