I have a very strange problem :
After a synchronisation with merge replication, my  local database  (.sdf)
has four  lines where every field is null, with the primary key.
In the device, i can't drop or delete the table.

Hello;
What i want is to pass a SQL CE database file created in the emulator to mi
PC... it is possible..?
I don't have any PPC device, so i think i can't use ActiveSync.

Using Visual Studio .Net to develop for a mobile application, is the only way
to communicate with a SQL 2000 server to use the SQL CE client (which appears
that even that can't directly communicate with SQL 2000, but must go through
IIS), or is it possible to simply use the ...

Just a positive word on using these newsgroups and the MVPs -
I know many times the problems posted here are ultimately  resolved by the
developers themselves after a little thinking, and usually in the ways
suggested by the MVPs.  But it REALLY helps to hear it over and over ("no ...

Does merge replication support clustering?
I'm having some troubles about  merge agent "querytimeout" parameter
throught a clustered system, and the hints that are over there about
"increasing timeout", "refreshing indices" and a lot more don't give any

I am trying to run the following statement:
SELECT IMEI, ProductCode, Quantity FROM (SELECT NULL AS IMEI, product AS
ProductCode, (physicalqty - allocatedqty) AS Quantity FROM importstock
WHERE (NOT mpstype IN(N'U', N'C', N'M', N'X', N'Y', N'P')) AND product IN

is it possible to do a join query between two different databases with SQL
Server CE? If so, please can you give me some infomations about the syntax.
Thanks,
Stefan

Please help me with this licensing question:
Microsoft says:
You can deploy SQL Server CE to an unlimited number of mobile devices
provided that they operate in stand-alone mode. In stand-alone mode,

I have created a replication with SQL CE. In Folder \Program
Files\Microsoft SQL CE\Server, a lot of file .IN and .OUT were created
for Merge Replication between DB on SQL server and DB on SQL CE.Those
file occupied such a large amount of disk space. I think I could

I'm having a heck of a time trying to determine if my query returned any  
values.  I am trying to implement a logon procedure, where if the user and  
password match a record in the database, then the user is authorized.  The  
below code works great at SELECTing in other ...

Why is there no true Close (OK) in Query Analyzer?  When you click the (X),
it leaves the database open then its not accessable to another program.
Then you have to go to Memory->Running Programs to kill it.  The (X) should
at least release the database and close it!

On my publisher database I have a table called TASKS. I only want to send
tasks from last week and next week to the subscriber, to minimize the amount
of data at the pda.
How come old rows still stay in the subscriber database as time moves on,

I open a single global SQLCe connection in my app and then use it in several
concurrent threads.  Very occassionally I end up with a corrupt database
that even Query Analyzer can't open.  This leads to 3 simple questions:
1) is there any problem with thread 1 writing to a table, ...

Does anyone know what it means when you get an exception on the SqlCeEngine
constructor?  I'm doing this:
  string src = @"DataSource = \My Documents\mydb.sdf";
  string dst = @"DataSource = \My Documents\temp.sdf";

Hi, Could you help me modify the SELECT statement below that would
accomplish my final goal.
SELECT col1, col2 FROM table1 WHERE col3 < @V
In col1 rows have many duplicates