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

x
?
Solved

What is "syspublications"

Posted on 2006-04-26
7
Medium Priority
?
1,805 Views
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'. ]
0
Comment
Question by:Mateen
7 Comments
 
LVL 143

Accepted Solution

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

Assisted Solution

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

Author Comment

by:Mateen
ID: 16550280
Hi,

<< 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.
0
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
0
 

Author Comment

by:Mateen
ID: 16550339
Problem solved.

Now writing.
0
 

Author Comment

by:Mateen
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

Done.


0
 

Expert Comment

by:moneywell
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'.

------------------------------
ADDITIONAL INFORMATION:

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

------------------------------
BUTTONS:

OK
------------------------------
0

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