Hi all, I've created a sdf database directly in my pocket PC and I was
accessing it with an application made with .Net Framework 1.1. Now I've
upgrade my project to .Net Framework 2.0 using Visual Studio 2005 Beta 2.
When the application tried to access sdf database I've got an ...

Hi group!!
   Is this possible create a table with 3 fields Primary Key in SqlServerCE?
CREATE TABLE Table (
field1 nvarchar(3) Primary Key,

How can I copy a database from my SQL Server 2000 to the SQL Server CE om my
pocket PC Device?
Thanks,
Shmuel Shulman

I am writing an application in VS2005 Beta 2 with SQL Mobile 2005.  Upon
initial load of the application, replication to the SLQ 2000 SP4 server
functions just fine.  
If I move around the application a bit, about 4 forms into it, then come

When synchronization fails using following command :
       pISSCEMerge->AddSubscription(EXISTING_DATABASE);
then I use following command to synchronize data :
      pISSCEMerge->ReInitializeSubscription(TRUE);

How can one connect to SQL Server CE I mean tools like Query Analyzer etc.
Thanks,
Shmuel Shulman
SBS Technologies LTD

I'm using SqlCE ver 2.0
I make a neew application with EVC 3.0
The size of my databse before compact is 7.82 MB
After the compact the database shrink to 2.18 MB

My table is created with this command:
"CREATE TABLE F50 (rNumRec int IDENTITY(1,1),rDeleted nchar(1),rCode nchar(7),rNumero nchar(3),rNom nchar(40))"
1) "SELECT rNumRec,rDeleted,rCode,rNumero,rNom FROM F50"
2) "SELECT rNumRec,rDeleted,rCode,rNumero,rNom FROM F50 ORDER BY rCode"

This is a Smart Device App with Windows CE.NET.
I experience a memory leak with the following code. Every time I append 500
records to my TestTable, I display a Messagebox.
If  and in the "Start | Settings | Control Panel | System | Memory" window,

This seems to be the case, although HasChanges appears to be there.  Is there
any shortcut besides walking thru my dataset looking for modified rows and
creating my own new dataset, like GetChanges would have done for me?

I'm trying to open SQL CE database from SQL Mobile Server (SQL 2005
CTP) it gives me something error like this :
*************************************************************
Invalid database version. [ Db version = 0,Requested version = 0,File

i have a sql server 2000 and a iis running on my win 2000 computer.
i want to intall the sql server ce but it always says, that there is a
SP Version conflict with my sql server.
i have sql server 2000 SP4 installed (says the info menu button on sql

I have a problem, SQL Server 2000 and SQL Server CE worked correctly, but one
day, splash!!! ERROR!!! 29045, Initializing SQl Server Reconcilier has failed
and 28539, The object is already initialized.
Any solution?

If i want to use Merge/Replication, is it okay if i already have my db
schema created on the device prior to bringing the server db schema which is
the same?
Thank you

I am getting this error when i connect with an RDA pull to a virual
directory which have anonymous access:
Error code: 80040E4D
Message: An Internal Error Occured. [ID,,,,]