Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  SQL CE Query does not return same on SQL Server

Author  Topic  bottojr Starting Member 1 Post Posted - 2004-10-18 : 19:59:33 Our setup is as follows: Two databases: Db1 has transactional publication setup Db2 has a pull subscription to Db1 AND merge publiction for pocket pc handhelds running SQL CE. When inserting a record into a table on Db1 - it populates over to Db2. However - this record is not seen after synchronizing the handheld to grab the latest using merge replication for some odd reason. However - if I go on the server and go to the field that was pulled over onto Db2 and change the field just by hitting the delete key at the end of the text (the field is numeric 9(18,0)) - it will then appear on the handheld. I don't even delete any text - it is like there are spaces at the end of the line that are not seen. Just hit the delete key a couple of times and it appears on the handheld. Anyone else seen this? - Brad