exec sp_addarticle
@publication = N'ReplicationName',
@article = N'MyObject',
@source_owner = N'dbo',
@source_object = N'MyObject',
@destination_owner = N'dbo',
@destination_table = N'MyObject',
@schema_option = 0x0000004008037FDF,
@status = 0,
@description = N'',
@type = N'logbased',
@creation_script = null,
@pre_creation_cmd = N'drop',
@vertical_partition = N'false',
@identityrangemanagementoption = N'manual',
@force_invalidate_snapshot = 1,
@ins_cmd = N'CALL sp_MSins_dboMyObject',
@del_cmd = N'CALL sp_MSdel_dboMyObject',
@upd_cmd = N'SCALL sp_MSupd_dboMyObject'
go
exec sp_addarticle
@publication = N'ReplicationName',
@article = N'v_myview',
@source_owner = N'dbo',
@source_object = N'v_myview',
@destination_owner = N'dbo',
@destination_table = N'v_myview',
@type = N'view schema only',
@description = null,
@creation_script = null,
@pre_creation_cmd = N'drop',
@schema_option = 0x0000000008000001,
@force_invalidate_snapshot = 1
go
exec sp_addarticle
@publication = N'ReplicationName',
@article = N'usp_myproc',
@source_owner = N'dbo',
@source_object = N'usp_myproc',
@destination_owner = N'dbo',
@destination_table = N'usp_myproc',
@type = N'proc schema only',
@description = null,
@creation_script = null,
@pre_creation_cmd = N'drop',
@schema_option = 0x0000000008000001,
@force_invalidate_snapshot = 1
go
exec sp_addarticle
@publication = N'ReplicationName',
@article = N'f_myfunc',
@source_owner = N'dbo',
@source_object = N'f_myfunc',
@destination_owner = N'dbo',
@destination_table = N'f_myfunc',
@type = N'func schema only',
@description = null,
@creation_script = null,
@pre_creation_cmd = N'drop',
@schema_option = 0x0000000008000001,
@force_invalidate_snapshot = 1
go
exec sp_refreshsubscriptions @publication = N'ReplicationName'
go
exec sys.sp_startpublication_snapshot @publication = N'ReplicationName'
go
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· DeepSeek “源神”启动!「GitHub 热点速览」
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 我与微信审核的“相爱相杀”看个人小程序副业
· C# 集成 DeepSeek 模型实现 AI 私有化(本地部署与 API 调用教程)
· spring官宣接入deepseek,真的太香了~