I'm using SQL CE 2.0 on both Pocket PC 2003 SE and 2002, CF 1.0 SP3
installed. My application offers a backup button for copying the database
file
to a different location on the device.

i need to list all tables in an SQLCE Database. How to do this ?
Laurent.

It is possible Creating SQLCE Database on Desktop Framework?
Because filling SQLCE database with Large Text File on Device is long
operation.
Do you know any tools?  or coming in future.

 I have a situation where I'm doing a small application for WindowsCE.Net
4.2 using Visual Studio.Net 2003. There is an access 2000 database on the
desktop that needs to be sync'd up to the device -- which is actually a hand
barcode scanner built around this CE device. I need to ...

I'm having a problem.
I'm inserting an record to a SQL CE table. The table has an identity column
plus other data column, (namely:  ID, ColA, ColB , and the rowguid)
When i execute the following SQL statement:

Hello, im developing a smartapplication in C#, and i must to make a
replication to the handheld, with "parameters", like customer = x, and then
only loads the data for that customer.
is there any whay that i could acomplish that?

In my other topic I make questions about the performance of SQL Server
Ce 2.0 and the new SQL Server Mobile 2005 Beta 2, and I found a new
doubt in my application that have a big performance problem with the
SQL Server Ce 2.0, my hardware (the PDA) has a processor PXA255 with

I am doing my first insert in sqlce with C#
my CommandText reads as follows:
INSERT INTO table(columnsList) VALUES (appropiateValuesWithOneApstrophe)
I get the following error and nothing is written to the table:

Is it possible to do this?  I see in sp_changemergearticle it isnt an
option but with a little hacking in MSRepl_identity_ranges in
distribution db and published db - also change 0 to 1 in
sysmergearticles for identity range handling for table it seems to

I want to create a view in SQL Server CE, I write the following: create view
vw_test as select field_1 from table_1
I receive the following error: DB_E_ERRORSINCOMMAND
Sql server CE supports views?

I have multiple users with anonymous subscriptions from their devices to the
server.
The filters on the publication are designed to remove old data from the
device as certain time periods elapse.

I'm writing a WinCE App that requires to synchronize with SQL Server 2000.
However, I'm facing a difficulty which for some of the tables, I need to do
Merge Replication (meaning Server and SQLce must contain same set of data)
and for some other tables, such as transaction records ...

   when i tried to creat a new virtual directory , i got a error which says
"the name you have chosen already exists, use a different name"
    but it does not exist in IIS.
  so anyone knows that how can i delete this account so that i can create

the software environment i installed are: winows advanced server 2000 + sql
server 2000 + sql server 2000 sp3 + sql server ce 2.0 + sql server ce 2 sp3,
but when i installed sqlce20sql2ksp3a.exe, it prompt error message"sql server
ce tools is compatible only with sql server 2000 ...

Darren,
This is a continuation of a thread we began over on
microsoft.public.pocketpc.developer.
My application is an older one.   It is a Win32 C++ non-MFC app developed