Sorry for bad english, I'm from Brazil.
I haven't found a way to improve performance of this query.
Thanks in advance for any help or reply!
This query use to take almost 6 min !!! With index on E.Estoque now

I recently installed this software, and I noticed that I am able to see it
using SQL server Management Studio, but when I try to add a
connection from VS2005, it does not appear as one of the available
data sources. I uninstalled, and installed it once more, but the same

I get the following error message when trying to ExecuteNonQuery a
SqlCeCommand with 88 named parameters:
System.InvalidOperationException: Too many SqlCeParameters specified in the
curr

I had posted a message a few days ago about how to go about accessing
remote SQL Server, but i didn't get any replies. So, i am posting it
again, but after rephrasing it a little bit.
I need to access a remote SQL Database from my pocket pc (Dell Axim

I want to delete record from my database, but it seems it is not working.
ExecuteNonQuery command is executed without exception, but in second step Im
loading the records from database, the previously deleted record is there.
I tried delete it in Query Analyzer and weird beahviour ...

Is there a way to use xml with Mobile 2005? I am using datasets at the
momment and they are very slow loading from the xml file. What advances will
I have from moble 2005?
chuck

I am new to SQL Mobile but have achieved simple connection to sdf file. Could
you point me to an article describing code to merge replicate (Pocket PC
2003) with SQL Server 2000 table? Pref VB.