IF NOT EXISTS(SELECT TOP 1 1 FROM master.dbo.sysservers WHERE srvname = 'srv_Lnk')
BEGIN
EXEC sys.sp_addlinkedserver
@server = 'srv_Lnk',
@srvproduct = '',
@provider = N'SQLOLEDB',
@datasrc = N'S1DSQL03\S7OVSDB04'
EXEC sys.sp_addlinkedsrvlogin
@rmtsrvname = 'srv_Lnk',
@useself = 'false',
@locallogin = NULL,
@rmtuser = 'EComDbo',
@rmtpassword = 'Ecom2Dev'
END
SELECT TOP 1000 * FROM srv_Lnk.CodeCenter.dbo.personal WITH(NOLOCK) ORDER BY NAME
EXEC sys.sp_dropserver
@server = 'srv_Lnk',
@droplogins = 'droplogins'
存储过程夸Sever访问
最新推荐文章于 2024-07-03 03:17:52 发布