SQL CE Replication - Failed to enumerate changes in the filtered articles

I have a SQL 2000 server running service pack 3a with security hotfix
SQL2000-KB815495-8.00.0818-ENU.exe applied. IIS and the SQLCE2 merge
agent are on the same machine. First time synchronisation to Pocket PC
is fine, but subsequent synchronisations fail (i.e. the snapshot gets
delivered OK, but merge replication is failing).

Here is the error log from my Pocket PC device - I've basically written
the SqlCeException and any inner exceptions to a log file.

---------------------------------------
Exception Type: System.Data.SqlServerCe.SqlCeException
---------------------------------------
Error[0/-2147467259]: .
---------------------------------------
Error[1/-2147200925]: Failed to enumerate changes in the filtered
articles..
---------------------------------------
Error[2/0]: {call sp_MSsetupbelongs(?,?,?,?,?,0,?,?,1,?,?,?,?,?,?)}.
---------------------------------------
Error[3/230]: SELECT permission denied on column 'intSurveyTypeID' of
object
'MS_biA4E61E0C791848119969937661E950B3_v_E4DF6AB3F3C54C08ADDC5E0BEE3AED42',
database 'Keystone_Train', owner 'dbo'..
---------------------------------------
Error[4/230]: SELECT permission denied on column 'intAssetID' of object
'MS_biA4E61E0C791848119969937661E950B3_v_E4DF6AB3F3C54C08ADDC5E0BEE3AED42',
database 'Keystone_Train', owner 'dbo'..
---------------------------------------

Not every device is failing, it appears to be device dependent. Any
clues? I am reluctant to upgrade to SP4 because it is a customer
server and they currently run SP3a across all SQL Servers.
Unfortunately I have been unable to reproduce the problem on my site -
but this could be down to the PDAs I'm using.

Ideas?

.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)