SQL Server 2005 - 名为 sp_MSdel_ 的存储过程与复制相关吗?
我的家庭办公室设置中有一台服务器,用于从我们公司总部的服务器接收推送订阅。我今天查看了存储过程列表,发现其中许多都带有“sp_MSdel_”前缀。这些与复制有关吗?它们可以/应该被删除或保留吗?
我在主服务器上没有看到任何这些类型的存储过程。
谢谢!
I have a server here in my home office setup to receive push subscriptions from a server at our company HQ. I was looking through the list of stored procedures today and see many of them with 'sp_MSdel_' prepended. Are these related to replication? Can they/should they be deleted or left alone?
I don't see any of these types of stored procs on the main server.
Thanks!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
这些表用于复制。不要删除这些过程,因为 SQL 代理将具有将使用这些过程的复制清理作业,并且是 MS 复制配置设置的内部内容。请别打扰他们。
These tables are for replication. Dont delete these procedures as the SQL Agent will have replication clean up jobs that will use these procedures and is internal to the MS replication configuration setting. Please leave them be.
它们用于复制。离开他们。
They are for replication. Leave them.