数据库操作连接局域网中数据库

declare @serverName varchar(20)
set @serverName='srv_lnk'
if exists(select 1 from master.dbo.sysservers where srvname=@serverName)
begin
    EXEC sp_dropserver @serverName,'droplogins' 
end 
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','192.168.45.34' 
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','Zxjc321' 
go 
insert into srv_lnk.monitorsystem.dbo.t_HistoryDataOriginal select * from monitorsystem.dbo.t_HistoryDataOriginal where IsUpload = 'N' and DataTime>=DATEADD(MONTH,-1,GETDATE())
update monitorsystem.dbo.t_HistoryDataOriginal set IsUpload='Y'where IsUpload='N'
go 
exec sp_dropserver 'srv_lnk','droplogins'