EXEC master.dbo.sp_addlinkedserver
@server = N'MyUserDB', @srvproduct=N'xxx.xxx.xxx.xxx', @provider=N'SQLNCLI', @datasrc=N'xxx.xxx.xxx.xxx'EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname=N'MyUserDB',@useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='mima'
执行以上代码
select * from MyUserDB.P_Self.dbo.P_SelfCul