Merge Replication initialization error

[aomara]

I have 2 Different server using SQL Server 2005 with SP2 in the same domain using LAN.

I establish Merge Replication between the 2 servers on one table "EMP".

Note: EMP table have 1 child table with a foreign Key, so I change the Article properties in the Publication to be "Keep existing object unchanged"

At point of initialization, we got the following Error Message:

"

Command attempted:
{call sp_MSsetconflicttable (N'EMP', N'MSmerge_conflict_REP_ABC_TEST_EMP', N'W-TIP-0302', N'ABC', N'REP_ABC_TEST')}

Error messages:
Incorrect syntax near 'EMP_NO'. (Source: MSSQLServer, Error number: 102)
Get help:

http://help/102

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help:

http://help/MSSQL_REPL-2147201001

"

Any one can HELP ?

 

[mrdenny]

Have you followed the troubleshooting instructions in the error message?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[aomara]

I change the Agent Profile of the Merge Replication Agent to be "Verbose history agent profile", but there is no place for specifing the output file.

I try to search for the log file in SQL Server folder "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL", but I failed.