Replication Issues

Hi,

I have created a publication in Microsoft SQL server 2005 and the publication credentials are used by an application targeted for a windows mobile 5.0 which using RDA pulls the data from the Master data file and creates a local symbol data file, the first part is working fine, i.e RDA pull from Sql Server 2005 to the SQL CE,

Now i am trying to add features where in the changes made by the application in the sdf in the mobile device are to be pushed back to the Master data file, for that i tried to use the RDA push command and for using the push command the primary constraint was the table shoule be tracked on when the data is pulled initially(i.e in the first RDA pull. tracking mode should be seton) but that has a setback for me, for when the tracking is enabled i am getting these columns

_sysIG bigint
_sysCG bigint
_sysCD datetime
_sysP1 varbinary(8000)
_sysMC varbinary(8000)
_sysMCS varbinary(8000)
_sysSR varbinary(8000)

as additional columns in my sdf file and these increase the size of my sdf file, is there any way by which i can stop them from replicating in the symbol data file without affecting the tracking option, for without the tracking option the columns cannot be pushed back to the MDF, can anyone give me insights on this?

Regards,

Venkatesh.M

These columns are required for the tracking mechanism to work. Please see this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=509110&SiteID=1|||

ErikEJ wrote:

These columns are required for the tracking mechanism to work. Please see this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=509110&SiteID=1

Thanks for the insight Erik.. i have solved the issue.. thanks