problem creating trans. replication /sp_MShelp_replication_table

I'm using the wizard to create a trans. replication. When it tries to
retrieve the tables to publish
I get this error:
New Publication Wizard encountered one or more errors while retrieving
the list of articles on 'production'. The list of articles may not be
complete.
Invalid column name 'options'. (Microsoft SQL Server, Error: 207)
The details of the error refer to sp_MShelp_replication_table.
When I run that stored proc I get:
Msg 207, Level 16, State 1, Procedure sp_MShelp_replication_table, Line
59
Invalid column name 'options'.
What could be the issue?
-Phil
I found the problem. The database was originally a SQL2000 db that was
being replicated. It still had some tables like sysarticles. I
dropped those tables and it's fine now.
|||The reserved replication keywords are :
If your publishing table has column names reserved for merge processing, you
will not be able to generate an initial snapshot because of duplicate column
names. Reserved column names are:
a.. reason_code
b.. source_object
c.. reason_text
d.. Pubid
e.. conflict_type
f.. origin_datasource
g.. tablenick
h.. create_time
Option is a reserved sql keyword. Could you post the schema for this table
here?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Phil Cruz" <philcruz@.gmail.com> wrote in message
news:1144171822.881370.203540@.z34g2000cwc.googlegr oups.com...
> I'm using the wizard to create a trans. replication. When it tries to
> retrieve the tables to publish
> I get this error:
> New Publication Wizard encountered one or more errors while retrieving
> the list of articles on 'production'. The list of articles may not be
> complete.
> Invalid column name 'options'. (Microsoft SQL Server, Error: 207)
> The details of the error refer to sp_MShelp_replication_table.
> When I run that stored proc I get:
> Msg 207, Level 16, State 1, Procedure sp_MShelp_replication_table, Line
> 59
> Invalid column name 'options'.
>
> What could be the issue?
> -Phil
>