Is there a way to disable the automatic insertion of apostrophes in the
query analyzer SQL command window?
When typing a field name for a field that ends in "_id" (key field) the
query analyzer in SQL CE automatically inserts an apostrophe so the

In a DTS run Sql that creates 6 tables of different
length. Then do a union to create on table with all
records in order by a certain sequence records 1,2,3,4,5,6
for each individual. Then in the Transform Data ask do

Using PPC 2003 / compact framework.
I am trying to copy data from one DataSet to another.  After calling
ImportRow on one DataSet's DataTable, the new row always contains blank
data.

I just wonder possible to download MSDE for pocket PC.
Is SQL Server CE compatible with Windows Mobile 2003 for pocket pc.
I intend to develop some pocket pc database applications.
Please advise.

Hy,
I have the following Cab-Files (SQLCE):
- sqlce.wce4.x86.CAB
- sqlce.wce4.armv4.CAB

Hi Anyone!
Can you create macro in SQL server. Like in Access you can create a macro to
update table (overwrite the data).
Thanks

When Need I to use reinitialize in my subscription with merge replication?
I Use a very complex dinamic filters.
Thanks a lot
Wend

I get this number of errors when I'm trying to merge replicate over GPRS. It
occurs only some times:
error 80072EE7 with native 28562
error 80072EFD with native 28562

I am using a simple connection string, e.g.,
"DataSource=\program files\myapp\my.sdf".
When using this connection string, a .net SqlCeEngine object creates my
database.  My connection object uses the same string while reading and

I would like to know if it is possible to design a sql ce database on the
desktop - under visio for example - and then how to deploy on pdas ?
thanks

Hello,
I use merge replication with anonym suscribes
I am trying to filter my donnees from a particular profil in a smart client.
So, I d like to use a function  to return replication.Subscriber.

Contemplating how I want to store my replication settings (per site may all
differ). My understanding is that XML is slower to and fro, which makes
sense. I see a security issue persisting any passwords as text, but
otherwise, what am I giving up using text file over XML?

Does sql ce uses a query serialization or any other more sophisticated
technique to provide thread safety?(I'm also very keen on knowing
which one).
I made some tests: two threads were parrallely updating the same row

hi, i have this situation, i have a transaction table and a transaction detail table, normally i would have an identity and use that identity to insert the details in the other table
for example
transaction
-----------------------