Ok, let me start by saying, this is an entirely new thing for me to me
doing. I need to create a connection from my mobil device to my main SQL
server. What I mean by this is that I need to pass a username and password
to my main db to a stored procedure, then with that ...

I'm trying to convert to Sql Server Compact Edition the TSQL instruction
that in Sql Server checks whether a table exists, and then delete it, such
as
if exists (select * from dbo.sysobjects where id =

I'm missing something basic here.   I'm following the basic example in the BOL.
I have vs 2005 installed and have referenced the following files (VB)
References:
Microsoft.WindowsC3.Forms

I have to reset the identity seed on one of my SQL Server CE (2.0) tables.
As far as I read, only TRUNCATE TABLE is my option. However, when I try to
use truncate in Query Analyzer, I get an error. So, how do I correctly reset
the seed? Ideally, I would be able to reset it to a ...

I'm using SQL Server Compact Edition as a Jet replacement in a desktop
app. What's the best way to deploy SQLS CE with my application? Is a
merge module available? Thanks
David Veeneman

I am working on an application that includes the ability to display a
map along with some information super imposed on the map in realtime.
Basically, my PDA is receiving geographic data from various sources
and I am writing that geographic data to a flat file as it arrives.  I

One of my clients is evaluating the possibility of integrating SS compact
edition.
The SSCE will be installed on desktop computers.
The general data flow will be an application on the desktop will store data

     Am new to PDA applications.I need to synchronise the data between my
PDA database and the sql database residing on my web server.my requirements
are
       * Initial database size is low but it may grow on .

Using C++ / Ole DB under Windows Mobile 5
Using the “Server Explorer” inside the IDE within VS 2005, I am looking at
the Column Properties of the “Photo” column, it says it is Data Type=Image
and the size=16 which seems all OK.

I'm experiening some very strange behaviour with Merge Replication. Records
are begin added in the device database, but are never being synchronised up
to the database server. This does not affect all records in the table,
sometimes they do make it and other times they don't, so ...

As per the details below, does anyone know how to upgrade a db on the
emulator. Since I don't have a real device, I am unable to use the tools as
mentioned below.
Database Upgrade Tool

i have this error when install on sbs2003 sp1 and sql2000 sp4.
"Sql server ce server tools is compatible only with SQL Server 2000
Service Pack 1 and higher. When you install Sql Server CE Server Tools on a
computer running both IIS and SQL server 2000 ensure the installer for Sql

First of all sorry my english.
I use FireBird database for pc application and sqlce database for pocket pc
application.
I try to replicate firebird and sqlce.

Does the new version of Compact SQL provide the CLR support as per the larger
editions.
Thanks

How is paging implemented in Sql Server 2005 CE?  I have seen that
additions to SQL Server 2005 include support for ROW_NUMBER()
function, but do not believe that it is supported for the compact
edition.  Are there any efficient ways to do this at all through sql?