I have a solution to develop that I don't have a clue to resolve it.
I will have a central database in SQLServer 2005 and several equipments
with SQL Server Mobile that I need to create with information stored in
the central system.

Is there any possibility to control the name of the primary key index when I
create a new table in SQL Server 2005 Compact Edition? Or can I change the
name of this automatically generated index later on?
If I create a table as follows

I am using vs.net 2003 with sql ce 2.0 and sql server 2000 sp2. I am
using replication of sql ce name SqlCeReplication. i am
constantly getting a error :
A request to send data to the computer running IIS has failed. For more

Is there a 4k limit on the size of a row?
If I create a table with columns of type nchar their total length must be
less than 4k. However, I can add a column of type ntext when I could not add
another nchar and I can add records to the table with text in the ntext col.

i am using vs.net 2005 i have add the reference of sqlserverce in the
project. When i create a database  on the device it gives me exception
"can't find PInvoke dll sqlceme30.dll". My code is :
Public Sub createDB()

I have simple SQL Mobile database with one table. This table contains
indexed field of type nvarchar(18). I write the following program:
SqlCeConnection conn = new SqlCeConnection(strconn);
conn.Open();

I've been looking over SQL Server 2005 CE (RC1)  for use in single-user
desktop applications. It looks like a good replacement for the Jet database
engine, except for one thing--how do I deploy it with my application?
I can't find any merge modules that install the SQL2005 CE ...