Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 7.0 "Cannot delete database" 1

Status
Not open for further replies.

DougP

MIS
Dec 13, 1999
5,985
US
whn I try to delete a particualr database I get an Error "3724 Cannot drop database 'Encore' because its published for replication"

can someon advise me where to Un-publish this so I can delete it. I was learning a while ago and added this database. Now we don't need it anymore. It has nothing in it anyway.

Tia
DougP, MCP

Visit my WEB site to see how Bar-codes can help you be more productive
 
In Enterprise Manager select Tools >> Replication.
The rest is pretty self explanatory.
the easier way is through the scratchpad.
click on replicate data, then click on remove replication.

Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top