Solved

Drop Replication traces in SQL 2000

Posted on 2007-04-03
2
382 Views
Last Modified: 2008-02-01
I am using SQL Server 2000.  I had a problem where a stored procedure is messed up and I want to overwrite it.  Howerver the database is replication all through the network.  I have not removed everything for replication that I can find and I am still unable to delete that stored procedure.  The message I get is unable to drop the procedure "procedure" it is being used for replication.

 I have removed all traces of replication that I can find but it still says under Replication Subscriptions that it has a subscripton.  When I try to delete the subscription it tells me the publication or the subscription do not exist.  How do I get this replication stuff out of there so I can rebuild my stored procedures?  This is very frustrating.  i will award multiple question points for this if I have to.  Please Help!!!!!
0
Comment
Question by:mfehrmann
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18847991
More than likely the replinfo column in sysobjects has a non 0 value.

run select * from sysobjects and look at the replinfo column. If there are any objects with a non 0 value run this command:

update sysobjects set replinfo = 0 where replinfo > 0

You many have to enable adhoc queries to system tables using this:

sp_configure 'allow updates', 1
go
reconfigure with override
0
 
LVL 10

Expert Comment

by:TAB8
ID: 18849251
Also try,
In EM
under tools\replication configure  diable publishing on the server .....

OR

http://support.microsoft.com/?id=326352 
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server maintenance plan 8 53
Rebooting Witness SQL Server 2 24
Connect remotely to SQL Server DB without TCP/IP enabled? 2 30
access to sql migration 5 22
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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.
Viewers will learn how the fundamental information of how to create a table.

735 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