Is there a way to pull the data from a previously pulled data from SQL
SERVER2000.
Do we always need to drop the current table and repull it. It is not so good
in terms of performance.

I am trying to return the last record entered from the Approvals table. I do
not want @@Identity as this will be the initial query to populate records.
Note that ApprovalID is the PK. The first Select clause is fine for ALL
records (and gives no exception), but the second one ...

I have this error when i try to synchronise (with replication fusion) (
"Initializing  SQL Server reconciler has failed - error 29045") , but when i
look the origine of this problem in the msdn site i find :  "Description: The
merge process could not load the Merge Replication ...

What type of licencing, if needed, do we need for SQL Server CE?....not for
development, for deploying to customers.
Evan Camilleri

I've read there that:
select table_name from information_schema.tables
can tell me if my table exists or not.
Ok. What then? Is there any good method to test if a table exists and if yes

   This microsoft article shows the scenerio of what I want to accomplish,
and hints at what can be done.
http://www.microsoft.com/sql/ce/support/default.asp replicating subsets of
published data filtered horizontally.

Is it possible to Synchronize with Alternate Synchronization Publications In
CE?

I have a Form with a DataGrid and I have realized the Replication Mechanism.
I created a button - when this button is pressed the data are synchronized
between a Sql Server CE Database on the PocketPc and the Sql Server Database
on my Desktop. The DataGrid is filled with Data ...

My Replication works fine when my PocketPc is connected via USB Cable with
the Desktop. Do I have to implement any additional things that the
Replication Mechanism also works with WLAN? (My PocketPc has WLAN). Is the
oRpl.InternetUrl the decisive factor? - because at this url I ...

I use schema rows to retreive information about data type in my table's
column. I use DATA_TYPE field from that view. I found a type indicator list
which indicates a data type, but for ntext, nchar and nvarchar the indicator
is the same (DBTYPE_WSTR = 130) and for binary, ...

Is it possible to delete rows of a dataTable in the SQL CE Query Tool? If
yes, how does it work?
regards
mat

Is there any equivalent of DBA_OBJECTS, User_Objects of Oracle in
SQL-CE.
Basically, my requirement is to find out whether a particular index or
foreign_key already exists in the SQL-CE Database or not.

I am running the following:
XP Professional SP2
SQL Server Developer 2000 SP3a
IIS

Should the RDA Pull, with Tracking Indexes On Include Foreign key
constraints? Or do I need to use DDL after the pull to establish the
fk constraints?
I am pulling from a SQL 2000 database with Foreign Key Constraints.

We are using RDA to read and write data between the SQL CE and backend SQL
database (using SQL Server AGent).  We use RDA.Pull to read data and
RDA.SubmitSql to write records.
We are looking into encrypting the SQLCE database.  Once I do this, will RDA