I am having problems with parameterized queries run on a SQL Server CE DB. I
don't know if this is down to limitations of parameterized queries or errors
in my syntax. All the queries I am attempting to run will work using
non-parameterizesed SqlCeCommands but only some work ...

I have a pocket pc sql ce database that gets larger in both number of
columns and number of rows - i.e. see following:
Customer1     Asset1     Asset2     Asset3    Asset~
Customer2

In the SQL CE code, you declare the publisher and
distributor sql instance name (note, not physical SQL
server name) and the IIS server where the sscesa20.dll is
located. I want to use an alias so that I can reference

When I do the following statement on an empty table, I get strange results.
I am using CE with the CF(C#).  The IsDBNull is not returning true even
though it returns a null value - then the GetInt32 returns a cast exception.
cmnd.CommandText = "SELECT Max(client_id) AS client_id ...

I have a table with one column that is an identity.
In sqlserver I can perform the following:
****
insert into table default values

Can anyone tell me how can i handle the problem that when i want to connect
to the remote sql server the pull method waits more and cannot get the data
from the server and returns error...I can connect to the sql server with
query analyser and get the data by running same sql ...

I have been trying to setup SQL CE RDA to move the contents of a SQL Server
2000 database to a SQL CE database running on the Pocket PC 2002 platform.  
My code is as follows and is based on an example in the book "SQL Server CE
Database Development with the .NET Compact ...

While i was pulling the date from remote database i got this message...Can
anyone tell me what is the problem?
Thanks...

From my ASP.net aplication, I am using the server explorer to connect to the
database and am writing the following  stored procedure :
CREATE PROCEDURE dbo.Check
{

I am running an application using SQL Server CE in a Pocket PC device.
Everytime a hard reset is done , the DB gets corrupted.  Is there anything
that  I can do to solve this problem?  Do anyone have experienced similar
problems?

There is "sqlce.wce4.armv4.CAB" which takes care of installation of SQL CE
2.0 on the pocket pc.
I want to do this manually, using one cab file which does other jobs too.
I register following dlls :

How do you learn the value of the Identity column on an insert in SqlCe?  I
don't have stored procedures to rely on (like select @id = @@IDENTITY), I'm
just doing a SqlCeCommand.ExecuteNonQuery call with my INSERT sql statment.
But next I need to insert related records using the ...

I develop an application to Pocket PC with .Net CF and SQL Server CE, using
an database in SQL Server 2000 SP3. I Using the rda replication.
When I make que rda.Pull operation, its works fine.
I add some rows in some table of SQL Server CE, that have the column

Does anybody know anything about SQL CE 3 support for the
1.0 version of the Compact Framework?

I am a SQL server 2000 developer working on a SQL CE app for the first time.
I am used to using server side functionality such as stored procedures ,
views etc.
I am aware that  such functionality  is not available in SQL CE.