Problem removing replication

Running SQL Server 2000. I removed the subscription and publication from a
database but the database is still showing that it is being replicated. I
have checked the tables in the distribution database and that database is not
listed. Anyone lese ver have this problem or now of a solution.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200610/1
The sp_dboption procedure will give you this information. Alternatively you
can use:
select name, databasepropertyex (name,'IsMergePublished') from
master..sysdatabases
select name, databasepropertyex (name,'IsPublished') from
master..sysdatabases
When you use sp_dboption you pass the database name as the parameter.
The output will look something like this:
The following options are set:
published
select into/bulkcopy
merge publish
trunc. log on chkpt.
auto create statistics
auto update statistics
If they are listed, you use sp_dboption to reverse the flag.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
"masmith via droptable.com" <u27472@.uwe> wrote in message
news:6834f742682f8@.uwe...
> Running SQL Server 2000. I removed the subscription and publication from a
> database but the database is still showing that it is being replicated. I
> have checked the tables in the distribution database and that database is
> not
> listed. Anyone lese ver have this problem or now of a solution.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200610/1
>
|||Thank you worked wonderful
Paul Ibison wrote:[vbcol=seagreen]
>The sp_dboption procedure will give you this information. Alternatively you
>can use:
>select name, databasepropertyex (name,'IsMergePublished') from
>master..sysdatabases
>select name, databasepropertyex (name,'IsPublished') from
>master..sysdatabases
>When you use sp_dboption you pass the database name as the parameter.
>The output will look something like this:
>The following options are set:
>--
>published
>select into/bulkcopy
>merge publish
>trunc. log on chkpt.
>auto create statistics
>auto update statistics
>If they are listed, you use sp_dboption to reverse the flag.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200610/1