sql server replication: I make a Transactional Replication,when I build the snapshot,a error occu
Error Message
The process could not bulk copy out of table '[dbo].[syncobj_0x4636333942323233]'
Error Detail
Invalid time forma
(Source: ODBC SQL Server Driver (ODBC); Error number: 0
and the script of view of [dbo].[syncobj_0x4636333942323233]

create view [syncobj_0x4636333942323233]as select [AI_nAdItemID],[AI_fPubDateDiscount],[AI_nPubDateDiscounterID],[AI_fProtocolDiscount],[AI_nProtocolDiscounterID],[AI_fLeadDiscount],[AI_nLeadDiscounterID],[AI_fEventDiscount],[AI_nEventDiscounterID],[AI_fCountDiscount],[AI_nCountDiscounterID],[AI_fOtherDiscount],[AI_nOtherDiscounterID] from [dbo].[AdDiscount] where permissions(270624007) & 1 = 1

i run the select clause of the view ,and no error occur, and the table of AdDiscount do not have any datatime fiel

what can i do? thanks a lot

can you post the schema of AdDiscount?

[quoted text, click to view]
[AI_nAdItemID],[AI_fPubDateDiscount],[AI_nPubDateDiscounterID],[AI_fProtocol
Discount],[AI_nProtocolDiscounterID],[AI_fLeadDiscount],[AI_nLeadDiscounterI
D],[AI_fEventDiscount],[AI_nEventDiscounterID],[AI_fCountDiscount],[AI_nCoun
tDiscounterID],[AI_fOtherDiscount],[AI_nOtherDiscounterID] from
[dbo].[AdDiscount] where permissions(270624007) & 1 = 1
[quoted text, click to view]