Actually I have this situation:
1) a desktop computer with activesync (called TERRA on my LAN)
2) a pocket pc with compact framework and sql server ce installed (and a
database winshow.sdf ready-to-use)

I'm working on an application that will be based on Pocket PC devices for
clients, and an office server.
The central server will hold all data, and mobile users need to hold their
own data and product catalog (up to 60 MB).

SQLCE 2.0, 23,000 row item table with text description column...
Is there a way to improve the lookup performance of this query:
select itemno, itemdesc from item_table where itemdesc LIKE '%4n%'
this returns 7 rows out of 23,000 in about 9 seconds...

does sqlce support "top" reserved  word in the select query. I have used but
i responded to me an error. If not, how can i handle to show some percent of
the data in my application. In my pocket pc application, i want to fill
datagrid initially top 50 rows but i cannot use "top" ...

Hello all I am currently doing a SQL statement that collects data from two
tables at once using a JOIN.
is it possible to do this on three tables at once?
we are putting the mar.itm_desc in a different table because many of the

I am working on a Windows CE .net / SQL Ce / C# program since august 2004,
and I have never been in trouble deploying the program to the target machine
(a Psion TekLogix, based on an ARM processor).
All of a sudden, today, the program cannot be launched anymore, and i get

how can i update a table field to value of another table field
for example:
update Table1 set Field1 = Table2.Field2
From Table1,Table2

I'm using SqlCE database, but I want to test it on the emulator. The
installation/deploy works fine, but the application does not start
automatically and I can't use the visual studio 2003 debugger
I have to start the application manually and put a lot of debug.write

Does anyone have a suggestion for getting a SqlServerCe database file on a
handheld device to a DB2 table? I have a network connection.
Thanks

can anyone help me to find out how to know the number of tables in a ce
database?
is there something like a system database for the sql ce which contains all
the information for the databse?

I'm working on a C# application using SQL server CE 2.0 as a data source.
The .NET CF version is 1.0.3316 and I'm using MS VS .NET 2003.
I created a DataSet object with a DataTable object inside. The DataTable
object is filled using a SqlCeDataAdapter object from my ...

Hi all, i've configured my IIS properly... I create the virtual
directory "CEAlias" which contains the sscesa20 dll...
The problem is that if i type on MY COMPUTER the string
"http://<MY_IP>/cealias/sscesa20.dll" on IE, the browser resolve it

I would like to create a database in SQL Server CE using VS.NET or SQL Server
2000 Enterprise Manager.
I'm running Win2K Professional, SQL Server 2000(don't know how to determine
the Service Pack I have), VS.NET 2003.

I am getting a NullReferenceException when using the Seek function of the datareader and I cannot figure out why.  I have verified everything I can think of including Index name, etc.  I checked the database to make sure that a value of "9" was in the column that is indexed and ...

i have a problem when droppin' an index, a message is sent from SQL CE Query
Analizer that says that the index is in use. If i try to drop that table, the
same error is sent,even when it is empty. ¿Any suggestion?
Thank You