This newsgroup has been great so far, hopefully I am able to contribute
some answers in the near future.
My question is how to synchronize relational data via RDA. My situation
is that I want to bring down some user-specific data to my device. This

Hi!!
I have a problem in my code and I can't resolve it.
I have to do many INSERT queries, and I need to execute them using the
CCommand::Open method (I know I have the option insertin data through CTable

Does anyone know the sql command (or any other programmatic way) of
removing the "Allow Null" property from a sql server ce column?  This
column needs to be a primary key for my table but I need to remove the
"Allow Null" property (it is there in the central database by wrongful

I call the following code:
SqlCeDataReader.GetSchemaTable().NewRow()
Where SqlCeDataReader is an object of that type.  I do that in order to
get a blank row that has the columns defined as in the table.  Then I

I am struggeling to change my merge agent to not use the default 300 second
querytimeout parameter.
I have created a new profile and increased it to 600/1500 with no luck.  I
have also editing the 2nd step in the agent properties and

Where can I find a good resource for finding best practices on creating a
publication that uses dynamic snapshots for subscribers using Sql CE.
Think it might be better than using static snapshots as I am using dynamic
filters and I could implement a solution whereby I could have ...

I've SQL 2000, SQL CE and WEB server on the same m/c which has
1) 2.5GB of RAM
2) IBM Netfinity 6000R/x Series 350
3) Intel Xeon dual CPU.

I Need to implement automatic update and installation in Pocket OC.
I need to preiodically update PC with New Version of application.
How can I do?
Thanks.

I'm having a problem using the RDA.Pull command with VB.NET.
Here is my Code:
Dim rda As SqlCeRemoteDataAccess = Nothing
           rda = New SqlCeRemoteDataAccess

I try to run a simple query on sql server ce 2.0 as such:
SELECT ColumnName FROM TableName GROUP BY ColumnName
or (basically the same query)
SELECT DISTINCT ColumnName FROM TableName

I need to debug an RDA problem that is occurring in the following
environment:  SQLServerCE 2.0 SP3a, WinXP Pro SP2, IIS 5.1, and SQL
Server 2000 SP3.
I've followed the MSDN article located at

I have an app that fills a grid from a SqlCeDatareader. The records to be
displayed in the grid are based on a user-defined search of a Sql CE database
table containing about 35,000 records. The search is always based on one
column which has an index. The app limits the number of ...

Is creating a database in sql ce the same in creating one in sql server 2000?

I am new to pocket pc development and to .net, i am developping a smart
client application using vs.net 2003 with its own database, so it will be a
sql ce database. How do i get sql ce and how do i install it within my app on
the pocket pc?

is SQL CE included in Visual Studio .Net 2003?