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!

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

SQL2K - Delete Subscription at distributor if DB is gone on Subscriber

Status
Not open for further replies.
MaYHeM24

MaYHeM24

IS-IT--Management
Aug 26, 2002
20
US
HELP PLEASE!
Our distributor server has a publication that has subscribed databases we can't delete, because the subscribed database no longer exists. Gives us Error 207: Invalid column name 'enabled_for_syncmgr' The subscription could not be dropped at this time. Any help would be greatly appreciated!!

SQL2K w/SP3 & MSDE 2K w/SP3 on Win2k Servers w/SP3 -=MaYHeM=-
-=IS MGR=-
 
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
158
TheBugSlayer
TheBugSlayer
DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
152
fredericofonseca
fredericofonseca
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
215
CodeWell
CodeWell
intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
99
intel233
intel233
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
153
JScannell
JScannell

Part and Inventory Search

Sponsor

Back
Top