Float data types not replicating correctly

We have a sql 2000 to sql 2000 transactional replication setup and we have
been getting sporadic issues with float data types not replicating correctly.
I understand that float data types are imprecise but this is causing issues
at the target site.
I have attempted to modify the target table and change the data type to
decimal but when we reinitialize the distribution fails with "String data,
right truncation" errors. Is there a way I can change the target data type to
decimal or force the data to replicate correctly without modifying the source
table as that is not an option.
Any other option to resolve this issue will be greatly appreciated.
Thanks,
Bill Stevenson, MCDBA, MCSE
SQL Server DBA
PeopleSoft Enterprise System Administrator
PeopleSoft Enterprise One CNC
IBM Certified Specialist - DB2 V7.1 User
ACS – Application Management Services
You would need a custom schema script to do this.
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"bstevenson" <bstevenson@.discussions.microsoft.com> wrote in message
news:02D80808-DE43-4A2A-8092-143EAC8D70FC@.microsoft.com...
> We have a sql 2000 to sql 2000 transactional replication setup and we have
> been getting sporadic issues with float data types not replicating
> correctly.
> I understand that float data types are imprecise but this is causing
> issues
> at the target site.
> I have attempted to modify the target table and change the data type to
> decimal but when we reinitialize the distribution fails with "String data,
> right truncation" errors. Is there a way I can change the target data type
> to
> decimal or force the data to replicate correctly without modifying the
> source
> table as that is not an option.
> Any other option to resolve this issue will be greatly appreciated.
> Thanks,
> --
> Bill Stevenson, MCDBA, MCSE
> SQL Server DBA
> PeopleSoft Enterprise System Administrator
> PeopleSoft Enterprise One CNC
> IBM Certified Specialist - DB2 V7.1 User
> ACS - Application Management Services
|||Consider using cast or convert fn's in sp_MSins & sp_MSupd on subscriber -
or use DTS to transform data before delivery...
Best option is to change data type at publisher - however if this is your
PeopleSoft system - it may take an act of congress to convice engineers of
poor datatype choice...
best of luck
ChrisB MCDBA
MSSQLConsulting.com
"bstevenson" wrote:

> We have a sql 2000 to sql 2000 transactional replication setup and we have
> been getting sporadic issues with float data types not replicating correctly.
> I understand that float data types are imprecise but this is causing issues
> at the target site.
> I have attempted to modify the target table and change the data type to
> decimal but when we reinitialize the distribution fails with "String data,
> right truncation" errors. Is there a way I can change the target data type to
> decimal or force the data to replicate correctly without modifying the source
> table as that is not an option.
> Any other option to resolve this issue will be greatly appreciated.
> Thanks,
> --
> Bill Stevenson, MCDBA, MCSE
> SQL Server DBA
> PeopleSoft Enterprise System Administrator
> PeopleSoft Enterprise One CNC
> IBM Certified Specialist - DB2 V7.1 User
> ACS – Application Management Services