<div>
Also try,<br />
In EM <br />
under tools\replication configure &nbsp;diable publishing on the server .....<br />
<br />
OR<br />
<br />
<a href="http://support.microsoft.com/?id=326352" rel="ugc">http://support.microsoft.com/?id=326352</a>&nbsp;
</div>


Also try,
In EM
under tools\replication configure  diable publishing on the server .....

OR

http://support.microsoft.com/?id=326352 [http://support.microsoft.com/?id=326352] 

<div>
<div class="content wysiwyg-content">
I am using SQL Server 2000. &nbsp;I had a problem where a stored procedure is messed up and I want to overwrite it. &nbsp;Howerver the database is replication all through the network. &nbsp;I have not removed everything for replication that I can find and I am still unable to delete that stored procedure. &nbsp;The message I get is unable to drop the procedure &quot;procedure&quot; it is being used for replication. <br />
<br />
&nbsp;I have removed all traces of replication that I can find but it still says under Replication Subscriptions that it has a subscripton. &nbsp;When I try to delete the subscription it tells me the publication or the subscription do not exist. &nbsp;How do I get this replication stuff out of there so I can rebuild my stored procedures? &nbsp;This is very frustrating. &nbsp;i will award multiple question points for this if I have to. &nbsp;Please Help!!!!!
</div>
</div>


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!!!!!

Drop Replication traces in SQL 2000

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.