Merge replication set-up problem

Hi All,

I'm trying to set up merge replication between two servers, and can create the snapshot without any issues, however, when I try to get a subscriber to pick up the snapshot, I get the following error

Command attempted:

{call sp_MSsetconflicttable (N'ADDRESS', N'MSmerge_conflict_HK2SH_ADDRESS', N'PYRITE', N'ProlawV11', N'HK2SH')}

Error messages:

Incorrect syntax near 'ADDRESS'. (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

I've had a look at various forums, but the only thing I could find was in russian and it wasn't especially clear. None of the MS links help and I've tried searching the MS site. Before I log a call with them, has anyone any ideas how to get round this?

Thanks
Dave

Can you post the schema of the Address table back here.

Also can you confirm that your publisher is Pyrite, your publication database is ProlawV11, and publication name is HK2SH?|||

Schema for Address table

CREATETABLE [dbo].[ADDRESS](

[ADDRESS] [varchar](36)COLLATE SQL_Latin1_General_CP1_CI_AS NOTNULL,

[CITY] [varchar](30)COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[STATE] [varchar](30)COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ZIP] [varchar](30)COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[COUNTRY] [varchar](30)COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Contacts] [varchar](36)COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AddressType] [varchar](40)COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[addrlines] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[IsMailing] [varchar](1)COLLATE SQL_Latin1_General_CP1_CI_AS NULLDEFAULT('N'),

[rowguid] [uniqueidentifier] ROWGUIDCOLNOTNULLCONSTRAINT [MSmerge_df_rowguid_4DDB619441DB4A7889BBCE245C68FF1C] DEFAULT(newsequentialid()),

CONSTRAINT [PK__ADDRESS__7D439ABD] PRIMARYKEYCLUSTERED

(

[ADDRESS] ASC

)WITH(IGNORE_DUP_KEY =OFF)ON [PRIMARY]

)ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

And you're correct in your assumptions about the publisher/tables/name/etc

Thanks

Dave