sql server replication: Hi I am trying to set up a transactional replication scheme with immeadiate and queued updating.. Everything is working fine except for one table when i include it as an article I get the following error from the Distribution Agent:

Implicit conversion from data type text to nvarchar is not allowed. Use the CONVERT function to run this query.
(Source: DS-FLASH (Data source); Error number: 257)
---------------------------------------------------------------------------------------------------------------
Implicit conversion from data type text to nvarchar is not allowed. Use the CONVERT function to run this query.
(Source: DS-FLASH (Data source); Error number: 257)
---------------------------------------------------------------------------------------------------------------

The last command is:

if (@@microsoftversion >= 0x080002C0)
begin exec sp_addsynctriggers
N't_sf_adhoc_CreditScoreResultsData',
N'null',
N'DS-LINC',
N'odin',
N'odin',
N'sp_MSsync_ins_t_sf_adhoc_CreditScoreResultsData_1',
N'sp_MSsync_upd_t_sf_adhoc_CreditScoreResultsData_1',
N'sp_MSsync_del_t_sf_adhoc_CreditScoreResultsData_1',
N'sp_MScft_odin_t_sf_adhoc_CreditScoreResultsData',
N'dbo',
N'null',
N'null',
N'null',
0x01000000000000000000000000000000000000000000000000000000000000,
0,1,
N'DS-LINC',
2
end
Transaction sequence number and command ID of last execution batch are 0x00007CAD00000FC2009800000001 and 881.

It only happens with this one table. There is nothing special about the table, just a bunch of varchar fields with 1 foreign key reference. It doesn't use any reserved words or non-conforming field names.

Any help or clues would be greatly appreaciated.

Thank you Paul for the response,

It is not a nosync initialization problem. The table was not on the subscriber. This happed on the distribution of the initial snapshot. The collations are also identical on both databases (default collation). Both servers are running sql 2000 sp3a. All of the other tables that preceed it work fine. When I run the sp_addsynctriggers as listed below in the last commad, I get the cannot implicitly convert text error.

Thank you.

[quoted text, click to view]