Can you enable logging (see http://support.microsoft.com/?id=312292) and
we'll see if this gives more info.
Rgds,
Paul Ibison

[quoted text, click to view]

Hi,

Thanks for the info. It did produce a error log,

Here is part of it. Maybe you can explain me ..It looks like it stops at
'MDP_COMPANY_OPCO' table. Am I suppose to check on that table for bad datetime ?

Thanks



Bulk copying snapshot data for article 'MDP_QUESTIONNAIRES_VALIDATION_PROPERTY'
select * from [dbo].[syncobj_0x4132434436323535] where 1 = 2
[9/27/2004 8:54:11 AM]MDPDB01.MDP2: select * from [dbo].
[syncobj_0x4132434436323535] where 1 = 2

Bulk copied snapshot data for article 'MDP_QUESTIONNAIRES_VALIDATION_PROPERTY'
(0 rows).

*** [Article:'MDP_QUESTIONNAIRES_VALIDATION_PROPERTY'] Bulk copy time: 218 (ms)
***

Bulk copying snapshot data for article 'MDP_IMPORT_LOG'
select * from [dbo].[syncobj_0x3732413137314345] where 1 = 2
[9/27/2004 8:54:11 AM]MDPDB01.MDP2: select * from [dbo].
[syncobj_0x3732413137314345] where 1 = 2

Bulk copied snapshot data for article 'MDP_IMPORT_LOG' (0 rows).

*** [Article:'MDP_IMPORT_LOG'] Bulk copy time: 219 (ms) ***

Bulk copying snapshot data for article 'MDP_COMPANY_OPCO'
select * from [dbo].[syncobj_0x4239333144443236] where 1 = 2
[9/27/2004 8:54:11 AM]MDPDB01.MDP2: select * from [dbo].
[syncobj_0x4239333144443236] where 1 = 2

Bulk copied snapshot data for article 'MDP_COMPANY_OPCO' (0 rows).

*** [Article:'MDP_COMPANY_OPCO'] Bulk copy time: 219 (ms) ***


*** [Publication:'MDP2'] Total snapshot generation time excluding publication
setup: 145578 (ms) ***

SourceTypeId = 4
SourceName = ODBC SQL Server Driver
ErrorCode = 0
ErrorText = Datetime field overflow
The process could not bulk copy out of table '[dbo].
[syncobj_0x4239333144443236]'.
Disconnecting from Publisher 'MDPDB01'






[quoted text, click to view]