Drop database

Dear All,
We want to drop a database on SQL Server 2000 which was replicated. The
publications were deleted. We also checked all the agents, jobs, etc and
nothing refers to the database being replicated. Despite this we cannot drop
the DB, we receive an error message the the DB is used for Replication.
Any help is highly appreciated.
Kolos
To see if the replication flag(s) are set , the sp_dboption procedure will
give you this information. 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
Alternatively:
select name, databasepropertyex (name,'IsMergePublished') from
master..sysdatabases
select name, databasepropertyex (name,'IsPublished') from
master..sysdatabases
You can use sp_dboption to reset.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||try this sp_replicationdboption 'database name', 'publish', 'false'
or
sp_replicationdboption 'database name', 'merge publish', 'false'
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kolos" <Kolos@.discussions.microsoft.com> wrote in message
news:FDD12443-4B40-4B3F-9893-08DF2DD5F6C5@.microsoft.com...
> Dear All,
> We want to drop a database on SQL Server 2000 which was replicated. The
> publications were deleted. We also checked all the agents, jobs, etc and
> nothing refers to the database being replicated. Despite this we cannot
> drop
> the DB, we receive an error message the the DB is used for Replication.
> Any help is highly appreciated.
> Kolos