如果发布服务器出现异常无法正常连接，第三方程序人工处理连接订阅服务器，这时由于服务器订阅过“事务发布”，出现第三方程序无法正常往数据库中插入数据。
This is a frum using English. So, you'd better edit your post for better support.
Good day,
As
@CosmogHong-MSFT
explained this forum is for discussions in English.
There are several forums in other languages including Chinese which are still active in the old MSDN interface (the plan is to close all these in the future and move the discussions here). You can try to find a relevant forum there but don't expect to much to get response as most people moved here
https://social.msdn.microsoft.com/Forums/zh-CN/home
You best option is to continue the discussion in English. I translate your question using Google so I could understand it
Question (translated with Google translator)
SQL Server 2019 Standard Edition, transaction release. How to delete the subscription on the Subscriber when the Publisher is damaged and cannot be connected
Due to copyright issues, "Peer-to-Peer Publishing" cannot be used, and "Transactional Publishing" is now used. No problem in normal use
But now there is a problem:
If the publisher is abnormal and cannot connect normally, the third-party program manually handles the connection to the subscriber server. At this time, because the server has subscribed to "transaction publishing", the third-party program cannot normally insert data into the database.
At this time, you can manually intervene to delete the subscription on the backup server (operate only on the backup/subscriber server, simulating that the publisher is abnormally inoperable). But there is a situation that cannot be deleted. . .
The purpose of deletion is to prevent the subscriber from ever subscribing to any publication. Just like a fresh install. How to do it? ! Thanks
To put it simply: How to completely delete the subscription on the Subscriber under the premise that the Publisher cannot be connected.
Response
In the following document you have a full explanation on how to delete a Push Subscription:
https://learn.microsoft.com/en-us/sql/relational-databases/replication/delete-a-push-subscription?view=sql-server-ver16&WT.mc_id=DP-MVP-5001699
In the following document you have a full explanation on how to delete a Pull Subscription:
https://learn.microsoft.com/en-us/sql/relational-databases/replication/delete-a-pull-subscription?view=sql-server-ver16&WT.mc_id=DP-MVP-5001699
I hope that this cover your needs ;-)
