• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1912
  • Last Modified:

What is "syspublications"

Sql Server 2000:

I am trying to delete an article from a publication.
My code is

exec sp_droparticle @publication = N'prod_b29', @article = N'order_from_det', @force_invalidate_snapshot = 1

I am receiving this error.

[ Invalid object name 'syspublications'. ]
2 Solutions
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Aneesh RetnakaranDatabase AdministratorCommented:
MateenAuthor Commented:

<< One option is to run the replication
script that comes in the INSTALL directory to recreate the replication system
objects. This way the syspublications will be recreated.

I completely did not understand.
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
in the installation folders of sql server, you should find a .sql file that is to (re)create the replication tables (search for syspublications in the files), and run that .sql file using query analyser
MateenAuthor Commented:
Problem solved.

Now writing.
MateenAuthor Commented:
1) You must be in a publishing database
2) Must drop subscriber first.
3) Then drop article.

use [prod_b29]
exec sp_dropsubscription @publication = N'prod_b29', @article = N'order_from_mst', @subscriber = N'all', @destination_db = N'all'
exec sp_droparticle @publication = N'prod_b29', @article = N'order_from_mst', @force_invalidate_snapshot = 1


I had tried running the .sql queries and now stuck while initialising the publisher; which prompted me the errors msg as follows:

TITLE: New Publication Wizard

SQL Server could not create publication 'test2'.


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


Invalid column name 'allow_initialize_from_backup'.
Invalid column name 'min_autonosync_lsn'.
Invalid column name 'replicate_ddl'.
Invalid column name 'options'.
Object 'test2' does not exist or is not a valid object for this operation.
Changed database context to 'DB'. (Microsoft SQL Server, Error: 207)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2153&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now