开发者

SQL Server 2005 - are stored procedures named sp_MSdel_ related to replication?

开发者 https://www.devze.com 2023-01-04 15:39 出处:网络
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 li开发者_如何学Pythonst of stored procedures today and see many of

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 li开发者_如何学Pythonst 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!


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消