I've ran into a problem where I cant get a table column size to be larger
than 8000 bytes. Is there a way to increase the size of the column? Its of
the type 'binary'. I'm creating this Sql Mobile database in Visual Studio
2005. If I try to make it larger it complains saying ...

I'm working on a smart device project, I need to download some data from SQLServer2005 database to Sqlce database. I tried to use  Microsoft Synchronization Services but I found that it does not support Smart Device projects.
Does SQLServerCe supports bulk Insert?
I tried to use ...

Before compacting a SQL Mobile 2005 database I run a DELETE command on
one table (because I have to transfer the data to another database),
but after the delete command and after the compacting operation the
primary IDENTITY KEY of this table restart from 1.

I am tring to insert a lot of records (about 10.000) in a local table on PPC
with SqlCE 2.0 and an application written with VB.NET 2003
I retrieve data from a SQL Server 2000 via Internet and parking them on
datatables. Then I use a sqlCeCommand to execute a bulk operation (insert

I am now getting the message:
Existing subscription already contains table included in the new
subscription.
Minor Error 28638.

I have an ipaq that is cradled on one machine and my sql server on another.
I can go thru internet explorer on the ipaq and get the sql server agent 3.0
message but when I try to replicate thru my app on the ipaq, I get:
Error Code: 80004005

I have two apllications. I database is using SQL Server 2005 Express Edition
while the other uses the mobile edition. I want to synchronize both the
databases. I know IIS is requires (for use of RDA). However, I am confused on
where to start for the synchroniztion. Do I need to ...

Hi, i've started a c# project using MS compact SQL as a datasource. I
am able to add tables in the server explorer and columns in these
tables, but how can i add relationships between tables (define a
column as a foreign key), such that when i add the tables as a

I am trying to bring back one record with one column that is defined as a
real number.  The error I get is invalid cast.  This is my code:
               _conn = new  
SqlCeConnection(PocketRigger.LocalStorage.ConnectionString);

I'm developing an application in C# using a sqlceCommand to execute my
DML command to insert or update my sqlce DB. With an insert statement,
my sqlceCommand is working perfectly.
   sqlcdCommand1.Execute()  //insert command

I'm trying to do something that I thought would be relatively
straightforward.  I have a SQL Server 2005 (Enterprise) database that
I'm trying to turn into a SQL Server CE database.  My database has
about 20 tables and about 100 data rows among those tables so I would

My database is located at "E:\MyDatabase#1.sdf"
I can connect to it via SSMS, but in VS2005 (emulator) when I configure my
connection string:
Dim cnn As New System.Data.SqlServerCe.SqlCeConnection

I would like to know i have to do to get the last IDNum created just after a
"INSERT" statement?
The IDNum is a filed that is auto-Increment.
Many thanks for your help.

Can anybody recommend a good book on developing and deploying mobile
database applications using SQL Server Mobile?  I am in the process of
trying to develop and database application and am a bit unclear on the
exact process of building and deploying a mobile database.

I need to create with a program written in VB 6 or VB.NET 2003 a database
SQL Server CE 2.0 and send it by email to many PDA. There is a method to do
so ?
Because of I would automatically generate a db on demand via Internet and