Can't disable publishing

SQL Server will not allow me to disable publishing; it just gets hung up and freezes. I have tried using the wizard in Enterprise Manager and I have also tried running sp_dropsubscription and sp_droppublication in Query Analyzer. I found Hilary's past p
ost on a similar problem that says to run the following code (below). What does this code do? I was wondering if it would help my problem. Or what if I just changed replInfo = 0? I just want to disable the publication. Thank you.
CREATE TABLE [MSdistributiondbs] (
[name] [sysname] NOT NULL ,
[min_distretention] [int] NOT NULL ,
[max_distretention] [int] NOT NULL ,
[history_retention] [int] NOT NULL
) ON [PRIMARY]
GO
this code was specific to someone who was disabling publishing on a database
which had been restored from another server where it was being published.
When you restore a published database from another server, some replication
objects are not restored and others are.
In this case this table was not restored and to disable publishing you need
to create it.
You are experienceing locking which indicates other factors at work. Try to
disable it again and wait till you get a response.
If you don't stop SQL Server agent and try again, or make sure all log
reader, distribution agents, and merge agents using this database are
stopped.
"Andrea Worley" <k_Rage@.hotmail.com> wrote in message
news:5180D4E7-0CE9-4B44-BE56-5CE5B82129A1@.microsoft.com...
> SQL Server will not allow me to disable publishing; it just gets hung up
and freezes. I have tried using the wizard in Enterprise Manager and I have
also tried running sp_dropsubscription and sp_droppublication in Query
Analyzer. I found Hilary's past post on a similar problem that says to run
the following code (below). What does this code do? I was wondering if it
would help my problem. Or what if I just changed replInfo = 0? I just want
to disable the publication. Thank you.
> CREATE TABLE [MSdistributiondbs] (
> [name] [sysname] NOT NULL ,
> [min_distretention] [int] NOT NULL ,
> [max_distretention] [int] NOT NULL ,
> [history_retention] [int] NOT NULL
> ) ON [PRIMARY]
> GO
>
|||I stopped the Log Reader agent and tried to drop the publication again, and it worked. Thank you so much.
-- Hilary Cotter wrote: --
this code was specific to someone who was disabling publishing on a database
which had been restored from another server where it was being published.
When you restore a published database from another server, some replication
objects are not restored and others are.
In this case this table was not restored and to disable publishing you need
to create it.
You are experienceing locking which indicates other factors at work. Try to
disable it again and wait till you get a response.
If you don't stop SQL Server agent and try again, or make sure all log
reader, distribution agents, and merge agents using this database are
stopped.
"Andrea Worley" <k_Rage@.hotmail.com> wrote in message
news:5180D4E7-0CE9-4B44-BE56-5CE5B82129A1@.microsoft.com...
> SQL Server will not allow me to disable publishing; it just gets hung up
and freezes. I have tried using the wizard in Enterprise Manager and I have
also tried running sp_dropsubscription and sp_droppublication in Query
Analyzer. I found Hilary's past post on a similar problem that says to run
the following code (below). What does this code do? I was wondering if it
would help my problem. Or what if I just changed replInfo = 0? I just want
to disable the publication. Thank you.
> [name] [sysname] NOT NULL ,
> [min_distretention] [int] NOT NULL ,
> [max_distretention] [int] NOT NULL ,
> [history_retention] [int] NOT NULL
> ) ON [PRIMARY]
> GO
>