I have one question for anyone that can answer it :
If the compact method of engine resets the identity column values to
the column minimun values.... ¿can I call this method if I use merge
replication and indentity values?. I think I can't do that because the

We have an access db which records daily orders. We would like the orders to
be downloaded to a windows mobile 2003 device via usb cradle. Drivers then
take along the device and get signatures from customers when items
delivered. Once drivers are back, the information to be synched ...

I have this error when trying to read SQL Server CE database data:
    A native exception occurred.
    ExceptionCode: 0xc0000005
    ExceptionAddress: 0x02c695a1

I have saved my signature as byte array in the sql server ce database. But
how can I convert the object when i retrieve the signature again from the
database to the byte array?? - because I only have a routine to draw back the
signature in the SignatureControl from the byte array ...

I am designing a mobile application. My records initially comes from the
data collected by pocketPCs.
Tehre many users. Each collects information at different places. So I need a
mechanism for primary keys.

After setting up this incredibly Rube Goldberg method of replication, I run
the code in the emulator to pull the initial subscription.... and all it
created were the system tables (MSysConstraints, MSysObjects,
MSysRDATombstone) and then gave me an exception on repl.Synchronize.

Are there any tools available to test SQL Server CE replication with large
number of devices. Looking for some way to run hundreds of virtual devices
and monitor behavior of web services and sqlserver. Something similar to the
Web Application Stress tool would be ideal.

If using rowguid as a primary key, does this then have to be converted to a
string when used as foreign key in a related table? If so, is there anything
to parse other than the curly braces?

I have some issues with configuring the SQL Ce with IIS server.
I did the following.
Both IIS and SQL Server is on same machine (WIndows 2003)
1. Created a new windows user in the server.

I have a one SQL Server 2000 and plenty of SQL Servers CE on PocketPC's.
My goal is to replicate the Server 2k changes into each SqlServerCE.
There is other set of data to be send to each SQL Servers CE.
For example stored procedures with parameter (POCKET_PC_ID) can give the

I tried to add in 500 records (all same values) continuously just for
brenchmarking purposes, but everytime it stops at 139th record with an
sqlceException. The exception contains no message, but has an HResult
= -2147024882. Anyone know what it means?

 There is a weird phenomenon that i can't understand why.
 My PDA, PocketPC 2003, SQL Server CE, synchronizes master data with
SQL Server 2000 by Merge Replication, and the local database file .sdf
is about 70 MBs. In memory, I saw:

How can I extract the year, month or day from a datetime field in Sql
ce? In the normal Sql Server I use the functions like YEAR, MONTH,
DAY, HOUR, MINUTE but these doesn't seem to be available in the CE
edition of Sql Server.

I am using merge replication running iis and sql server 2000 on the same
machine.
My question is: how can i implement (or simulate) integrated windows
authentication for mobile users connecting via the Internet?

Is it possible to create a column for a merge replicated subscriber
table in SQLServer CE. Whhen i try to add a column thru the Alter
table it gives me DB_E_SEC_PERMISSIONDENIED (Native Error code (0))
with Interface defining error: IDD_ITableDefinition. I am able to add