Do I understand it correctly when I say that the Compact Edtion RC1 only
runs on the Desktop and Tablet?
If yes. In the final version will we be able to run it on Windows CE as
well?

I am working in the SQL Server 2000 and Share Point Portal Server; we are
maintaining the SQL Backup for all the sites,
one of the users has deleted accidentally a document library from a
particular site. Can you please help me in restoring the particular document

I have problem with traping errors.
All errors reports only this constant message box:
"Errors occured.[,,,,,]"
I use SSCE with Delphi and ADO (Connection, recordset and other objects).

I found this site about licensing questions:
http://www.microsoft.com/sql/editions/sqlmobile/howtobuy.mspx
but I've got one additional question.
If a user has an Desktop Application which gets sometimes data from a

Man, I can not find these answeres anywhere. I was reading in the SQL
mobile document that ntext is available to use on Sql Mobile. it states
the following.
ntext

an SQL-Select on a  SQL Server Mobile Databse (Select t1.* from Table t1)
takes about 4 seconds (50 Rows) !!!
I tried using the SqlCeDataAdapter and SqlCeResultSet. But same performance
problems.

Doesnt sqlCE support subqueries as in:
SELECT  test. foo FROM (SELECT '123' AS foo) test
Is there a workaround for this?
TIA

does anyone know of any good books about SQL server CE 3.0 for
developers? I was looking on-line for books and really only came across
SQL server 2005 books with a small section on SQL CE 3.0..
Jay

Just noticed that MS has released SQL Server 2005 Compact Edition. As I
understand it this will replace SQL Server 2005 Mobile Edition.
I want to know what are the diffences between the two. What I've picked up
CE will be able to run both on PDA and PC. But are there any other ...

Is it possible to retrieve the identity value of a newly inserted row using
SELECT @@IDENTITY when you are executing within a transaction?
Sample code overview:
sqlCmd1.CommandText = "INSERT INTO T1 VALUES..."

I am about to start a project that would require me to backup data that
is stored in sql mobile. it is currently scheduled to work on a Win CE
5 device as well as a few windows mobile devices.
do you have any suggestions on how to backup this DB assuming we have

My boss happily announced he was grabbing the SQL Server Compact Edition
bits RC1 just released and he's calling it SQLServer CE.
I told him SQL Server CE has been out for years and he says it's the
"desktop" bits.....i suppose meaning the old SQL Server Everywhere stuff.

   The links to download the CTP are not working any more after the change
of name. Do you know if it is possible to download from somewhere? Or event
better any news about when a new CTP with the new name will be available?
  Thanks in advance for your answers.

A general question about the upcoming release of SQL Everywhere and
deployment. I understand the desktop restriction has been lifted, so I have
been looking at this as a good choice for production/shrink wrap apps.
However, I also noticed that when we deploy the CTP at the moment, ...

We are using a session object for Database transactions and the session is
getting terminated after some time(before the end of the transaction), which
is leading to inconsistency in data.
Could you please let me know whether there is a way to change the default