does anyone know how to use @@IDENTITY with
SQLCE Server to return the ID of the last inserted
record?
Thanks,

I want to sync the smart device system datatime to my server when my
application starts. how to go about this.
V Suresh

I have a confused problem that When database on SQL Server is changed I want
to refresh the table that on the PPC. I have pulled the table at PPC app
running successful. Must I repull the table when need refresh? But After I
repull the table in EVB ButtonOnClick method, It return ...

I have been trying to get replication to work between my pocket pc sql ce
database and my sql server 2000 database.  I am thinking that the problem may
be in sql server 2000 installation.  Here is why I am not sure if it is
installed properly.  When I installed sql server 2000 ...

I'm just starting to study my options on replicating a database on several
handhelds.  Do I need to programically recreate all of the details of my SQL
2000 database in SQL.CE on the handhelds, or will it automatically be created
if I use Merge Replication.

How can I make connection between SQL server 2000 and SQL
server CE? I want to get the table from SQL server 2000
into SQL server CE, can i achieve this?
Regards,

How can I make connection between SQL server 2000 and SQL
server CE? I want to get the table from SQL server 2000
into SQL server CE, can i achieve this?
Regards,

what is the best way to move data tables from and to PDA running sql CE and
SQL server 2k?
TIA,
mcnews

Being a newbie isn't easy, while developing a sqlserverce application I encountered some problems but know I'm really stuck.
After numerous errors (including 29045) now I get no errors at all the only message i get with MsgBox(SqlError.Message) = "0"
I really don't have a clue ...

Hello...
I created 4 publicatons on my SQL2K server that I use with Merge Replication
to send/recv data to/from some PocketPC devices.  Three work fine, but one
constantly fails.  Unfortunately, the error message only reads "Run".  That

I posted this in the pocketpc.developer newsgroup but maybe this is the
place to ask....
I have created a VB.NET CE Pocket Pc 2002 application, and I need to load a
combobox really fast from the SQL CE database...

I have a SQL Server 2000 database (.mdf file) and want to transfer it to SQL
Server 2000 CE (.sdf file).
How can I do this? I thought of exporting raw SQL (as inserts) but can
figure out how to do it.

does anyone have any pointers or suggestions for
writing my own insert command for sqlce.  I get an
error when I use the code a command builder
generated.  Code that be due tot eh GUID fields

I have just completed an insert of 3500 records
from and access DB into SQL Server 2K using
the import wizard.  The data is selectable on
my PC, but has not been replicated onto my

I am in the process of creating a new DB for
replication on my PPC.  The wizard will add
a GUID field when it is run so the tables will
contain a GUID field.  However, should I