[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


What is "syspublications"

Posted on 2006-04-26
Medium Priority
Last Modified: 2012-05-05
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'. ]
Question by:Mateen
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 1000 total points
ID: 16550221
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 1000 total points
ID: 16550231

Author Comment

ID: 16550280

<< 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.
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16550306
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

Author Comment

ID: 16550339
Problem solved.

Now writing.

Author Comment

ID: 16550343
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



Expert Comment

ID: 21303967
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



Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question