*.sch files in snapshot folder

Hello,

I'm encountering the following problem when applying the snapshot in the
merge replication (SQL Server 2005 STD - publisher and SQL Express -
subscriber):
- the *.sch files contain always CREATE TABLE statements with additional
rowguid column, but in the subscriber's DB the table already exists. In
result I get the error message 'syntax error near 'idart'', where 'idart' is
a PK of a table

I've modified then *.sch files and replaced CREATE with ALTER - only to add
the new column - and everything works fine. Anyway, when changing the DB
structure the sch files are numerated in other order, so every time I have
to re-numerate my, changed files.

Shouldn't the replicated tables be present in the subscriber's DB before
running the snapshot. What should I do to have this working without my
changes?

Thanks in advance.
Tom

can you post the schema of a problem table.
"Tom" wrote in message

> Hello,
>
> I'm encountering the following problem when applying the snapshot in the
> merge replication (SQL Server 2005 STD - publisher and SQL Express -
> subscriber):
> - the *.sch files contain always CREATE TABLE statements with additional
> rowguid column, but in the subscriber's DB the table already exists. In
> result I get the error message 'syntax error near 'idart'', where 'idart'
> is a PK of a table
>
> I've modified then *.sch files and replaced CREATE with ALTER - only to
> add the new column - and everything works fine. Anyway, when changing the
> DB structure the sch files are numerated in other order, so every time I
> have to re-numerate my, changed files.
>
> Shouldn't the replicated tables be present in the subscriber's DB before
> running the snapshot. What should I do to have this working without my
> changes?
>
> Thanks in advance.
> Tom
>