New Publication Wizard encountered one or more errors while retrieving the list of articles

Question

New Publication Wizard encountered one or more errors while retrieving the list of articles

philcruz

Ten Centuries

Points: 1004
More actions
April 4, 2006 at 11:21 am

#365832

I'm trying to set up transactional replication. When I launch the wizard I get the error below. Any ideas?
-Phil
TITLE: New Publication Wizard
------------------------------
New Publication Wizard encountered one or more errors while retrieving the list of articles on 'mydatabase'. The list of articles may not be complete.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantInitArticleList&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Invalid column name 'options'. (Microsoft SQL Server, Error: 207)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

philcruz Ten Centuries Points: 1004 More actions · Answer 1

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.