I have a little problem with connection beetween Win CE 5.0 on Symbol 9090
device and SQL2005.
Simply code:
conn.ConnectionString = "Data Source=192.168.1.2; Initial Catalog = zzz;

I have a table with two columns: an identity column (ID) and a Timestamp.
Both of these are indexed (non-clustered.) I want to retrieve the highest
identity column. So, which of the two is faster: SELECT MAX(ID) FROM Table
or

How can I syncronize two sql mobile 2005 databases?
There is a way or I must implement it by my self?
And In the SQL Compact Edition is this possibile?
Thank's in advance

This is my second try.
It's very important for me to resolve this problem. Otherwhise I have
to switch the program to an other progamming-language. Which would be
a havy work without knowing if there are other problems I can't solve.

I have been trying to access SCL CE database from outside Visual Studio,
for example using stand-alone Crystal Reports 8.5 and from Excel. Note:
Using it on a desktop PC
First of all the provider for SQL Compact is not displayed when

We have SQL Server 2000 running and we are intermittently getting the
following error.
Event ID 17055,566: error writing audit trace. SQL Server is shutting down
Has anyone experienced this?

What is the latest version of sql server for Mobile devices. I have a TREO
700, and would like to get sql on it. Where do i get it?

I've a lot of  sql server 2005 little databases, each one has its own
publication to a mobile sql ce database.
I'm searching a tool to manage the conflict, because the conflict viewer is
very slow and loads each co,flict for each table for each publication in