Is there a tool that converts SS05 dbs to an .sdf file ?
I've tried Primeworks Data Port Wiz , but it will only copy the .sdf file to
a device , not onto the local file system.

What is the best way to reset the index on an auto-incrementing field back
to 1 after all the data in its table has been deleted?
IDENTITY(1,1) ??
The tables were originally created with an IDENTITY(0,1)

Could you please let me know whether casting is possible in SQL Server Mobile.
If possible, let me know the syntax of converting a value of datatype of int
to nvarchar.
Thanks in Advance...

Is anyone using this successfully?  I thought this was the place to ask
questions regarding this technology but this newsgroup appears to be pretty
dead.  Any MVPs out there that could lend a hand - please......
TIA

Let me approach this from a slightly different angle as it seems like i'm
not getting answers to the questions the way I'm asking.  I've googled
senseless the web without an answer.
In SqlServer CE 2, you could call sscesa20.dll and get the familiar "SQL

I'm developing an app in VS2005, and want to use RDA to pull from a SQL
Server 2005 database.
I find that I don't have the virtual directory for the agent set up like I
do for SQL Server CE 2.0 with the directory pointing to a physical direcory

i try to execute this sql code,
update tmp set vol=a.qt
from tdetailvisite as a inner join tmp on a.idprd=tmp.idprd
where a.idvis=165032 and a.idtypaction=2

Hi you all.
I've to sync a db on pda with a db sql server through http.
Any tools are avaiable or i've to develop it manually?
(I couldn't see Sql Server CE till next week, so i'm looking for info

I have a big problem.
I try upgrade my soluction to CompactFramework 2.0, my aplication use a
SqlCeDataAdapter's from System.Data.SqlServerCe. It to work need the to
imports from System.Data.Commom.dll, too.

I have a strange problem with mobile devices using SQL CE merge replication...
On some devices, some system columns of merge tables are not created (and of
course, devices can't sync anymore)
Columns not created: S_generation and s_rowlineage but the rowguid  columns

I tried to created a new subscription in SQL 2005 Mobile to a publication at
the SQL 2005 Server. Both servers installed in the same computer. The
publication at the SQL 2005 Server was successfully created and I even
created a local subscription to it and it works fine. However ...

I'd like a Compaq/HP, can any one recommend the cheapest model to do
replication testing?

Does anybody have any sample code for Compacting a database in SQL 3.0 using
VC++?  My 2.0 code won't compile.  And looking at the new *.H files, it
looks like things have been changed around..
Thanks

i hope you can help me.
Following Problem:
I' ve got a mda 2 compact with windows mobile 5 on it and now i'm
trying to make an installer,

I am new to SQL CE.
How to get the list of tables in a database? In C#.
Thanks for your help...
DW