@ (255),
@ (255),
@ (255)
--請在執(zhí)行前,根據(jù)實際情況修改下列變量
@ = '目標(biāo)服務(wù)器名',
@ = '目標(biāo)數(shù)據(jù)庫',
@ = 目標(biāo)數(shù)據(jù)庫密碼
if ( from .dbo. where ='鏈接服務(wù)器名')
exec @ = '鏈接服務(wù)器名',@ =''
--增加鏈接服務(wù)器
exec @ = '鏈接服務(wù)器名',@='',@ = '', @ =@, @ =@
--增加鏈接服務(wù)器遠(yuǎn)程登錄
exec @ = '鏈接服務(wù)器名',@ ='False',@ = 'sa',@ ='sa',@ =@
--配置參數(shù)
exec @ ='鏈接服務(wù)器名',@ = 'use ',@ ='false'
exec @ ='鏈接服務(wù)器名',@ = ' ',@ ='true'
go