天安门车祸,李宗瑞梁婖婷qvod,游戏机之家
exec sp_changedistpublisher 'testsyncdbserv', 'active', 'true'
update t set t. publisher_id = 2 from dbo.[mspublisher_databases] t where id=2
update t set t. publisher_id = 2 from dbo.mspublications t where publication_id=2
exec master.dbo.sp_addlinkedserver @server = n'testsyncrptserv', @srvproduct=n'sql server' exec master.dbo.sp_addlinkedsrvlogin @rmtsrvname=n'testsyncrptserv',@useself=n'true',@locallogin=null,@rmtuser=null,@rmtpassword=null update dbo.msdistribution_agents set publisher_id=2,subscriber_id=3 where id = 4
update dbo.mssubscriptions set publisher_id =2,subscriber_id=3 where publication_id=2
update [mslogreader_agents] set publisher_id =2 where id = 2 update [mssnapshot_agents] set publisher_id =2 where id = 2 update t set t.job_id = sj.job_id, t.job_step_uid = sjs.step_uid from dbo.mslogreader_agents t left join dbo.msreplication_monitordata sm on sm.agent_name = t.name left join msdb.dbo.sysjobs sj on sj.name = t.name left join msdb.dbo.sysjobsteps sjs on sj.job_id = sjs.job_id and sjs.step_id = 2 update t set t.job_id = sj.job_id, t.job_step_uid = sjs.step_uid from dbo.[mssnapshot_agents] t left join dbo.msreplication_monitordata sm on sm.agent_name = t.name left join msdb.dbo.sysjobs sj on sj.name = t.name left join msdb.dbo.sysjobsteps sjs on sj.job_id = sjs.job_id and sjs.step_id = 2
update [dbo].[syspublications] set snapshot_jobid=0xd2e257afd287304ca2fc14f3d7c1aecf update [dbo].[syssubscriptions] set distribution_jobid=0x0e79d3a2a36f73409db3f4261723f37a
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
数据库SQL---数据库、基本表、视图、索引的定义、修改、删除
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (上)
在 Azure CentOS VM 中配置 SQL Server 2019 AG - (下)
网友评论