I am new to the Compact Edition. I have converted an Access Database to SDF.
Now I would like to generate the script for my new ce database, but i cant
figure out how to do it; all my usual ways  in SQL 2005 standard edition are
unavailable in CE.

Is there any way in SQL Server 2005 Pocket Edition to query what
INFORMATION_SCHEMA views are available and what columns each view
contains. I need this to build an object browser into my database
tool.

Using C++ with OLE DB, with IRowsetChange->SetData() – it seems at times, the
function works OK, and I can see the changed data in the table, in other
times I can’t
I read about immediate Updates or deferred updates, but I thought if I am

It is possible a replication between two SQL Compact edition
databases ?
I explain : two mobile applications (for exemple delivery) connect
itself to change information like adress contact of each mobile.

I´m trying to update my old server with SQL 2000 Standard with SQL CE 2.0 to
SQL 2005 Sp1 Express, I work with EVB...
Is this possible???
Thanks

I am sure that lots of people must know the answer to this but I can't find
it anywhere.
If I want to insert a Firstname and Surname into an SQLCE table called
Clients I would use

I have tried to do this using the Link Table Wizard - Selecting :
New Source
Other/advanced
Microsoft SQL Server 2005 Mobile Edition OLE DB Provider

I guess the first question is"
I use the SQL Server Management Studio Epress to create the Compact edition
database. Correct?
The online help is telling me to open the Object Explorer in Sql server

  I'm new to SQl CE 2.0 programming.
We are using eVc++3.0 environment to build the application. We have managed to create DB and then tables and also to insert records into the DB.
But when i tried to retrieve the rows i inserted into the table i was not able to get it.
I tried ...

I developed an application that generate sql server ce database(sdf
file) from a desktop database(sql server desktop). The sdf file was
distributed to the PDA users and used by an application on PDA(which
was deveoloped using C#.net).

           I'm Sasikumar, started to work with SQL CE DB.
I have seen your postings in forum regarding the OUTOFMEMORY problem,
we are also facing the same problem. If could help us on how to solve
then it would be more useful for us.

I have a question about indexes and the orders that actual rows are written
to an SQL Server CE/Mobile database. Let's say I have a table Table1 with 2
columns, Timestamp and ID. Let's say that the ID is an identity column and I
perform a series of inserts to this table so that I ...

As per the details below, does anyone know how to upgrade a db on the
emulator. Since I don't have a real device, I am unable to use the tools as
mentioned below.
Database Upgrade Tool

is there an api that allows to change the password to access the
database?
Thanks in advance,
         Carlos.

I create a PPC-Program in c#
my Objects conEnceDB, cmd and dr ar placed in my Form1
  namespace enceAblesung3
  {