How large can my sqlce database be, in theory and in real life.
right now my DB on the desktop is 1.5GB
Can I get all this data in sqlce?
Can I use merge replication with this amount of data?

I've two tables AZ01 and AZ02 the structure is the same.
Table AZ01 has 1.681.000 rows and AZ02 has 1.700.000 rows.
I execute the following select: SELECT COUNT(AZ01.COD) AS Conteggio FROM
AZ01 INNER JOIN AZ02 ON AZ01.COD=AZ02.COD

I have an application written in eVB using SQL Server CE version 1.1
and replication. We are considering creating a new version of the
application using the .NET Compact Framework with SQL Server CE version
2.0. However, we would like individuals with older devices to continue

I m trying to create tables using sql statments in an sqlserverce, but I
m getting errors. Can't I do that ?
If no, how to programatically create tables if the PC of the backend
office don't have sqlserver (thus can't pull tables) ?

Usually when i install a project on a handheld device through vb.net
IDE, the required files are installed automatically.
I would like to know what are the sqlserverce dlls to install on a
machine in case I don't want to (or can't) use the IDE for this purpose.

I am some what of a novice about Sql so I was looking for some help.
I have a table with a column defined as "mpchg nchar(1) not null default('
')".
I want to change this column to a nchar(10) but when I use the command

I am trying to create a field in my database which accepts a long string. In
standard SQL, nvarchar accepts up to 4000 char in length, but SQLServerCE
seems to limit the length up to 255. The ntext data type seems to be my only
option--it can get pretty big, though.

I have got an error with a Primary Key.
Error code 0x80040e38 DB_E_CONCURRENCYVIOLATION
It can't retreive some PK, but if I try to insert these PK, I have got a
duplicate key,

Ok;
I see in the forums that this line of code should work, but if i use it, the
SqlDbType to select the type of record doesn't work.
cmd.Parameters.Add(new SqlCeParameter("param1", SqlDbType.Int))

I'm having trouble performing an RDA.Push on a table that has the owner of
privuser and not the default dbo.
When I do the pull the sql has to specify privuser.tablename in order for
the pull to work. Otherwise the error of table not found is thrown.

I am developing a mobile application for Pocket PC and using Pocket PC
2003Emulator.  I am using RDA to pull and push for data transfer between
pocket pc and server.
Among many tables I am  pulling on empty table which gets populated by a

Hello, I've this select string:
SELECT (convert(nvarchar,DATEPART(HH,GH_Noleggi.OraConsegnaRichiesta)) +
':' + convert(nvarchar,RIGHT('00' + convert(nvarchar,DATEPART(mm,
GH_Noleggi.OraConsegnaRichiesta)),2))) AS OraConsegnaRichiesta

Hello;
How can i populate a table with multiple records but by code:
I tryied this, but if i want to add 4 records, i have to do the 2 lines of
code 4 times.

I am using VS.net 2003 with SQL Server 2000 sp2 and when I try and install
SQL CE I get a message about "SQL Server CE Tools is only compatible with
SQL Server 2000 Service Pack 1 and higher. When you install SQL Server CE
Server Tools on a computer running both IIS and SQL ...

Anyone know if its possible to apply a dynamic snapshot to a device?