SQL创建DBlink

USE
master
EXEC master.dbo.sp_addlinkedserver @server = '192.168.1.1', @srvproduct='SQL Server'EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname='192.168.1.1',@useself='False',@locallogin=NULL,@rmtuser='sa',@rmtpassword='123'
GO

posted @ 2023-02-15 16:49  未风  阅读(80)  评论(0编辑  收藏  举报