建数据库连接服务器
EXEC sp_addlinkedserver
@server='fundgame_812',
@srvproduct='',
@provider='SQLNCLI'
sp_linkedservers
sp_dropserver fundgame_812
sp_addlinkedsrvlogin @rmtsrvname = 'fundgame_812', @useself = 'false', @locallogin = 'fundwin', @rmtuser = 'fundwin', @rmtpassword = 'Win&Fund123'
select * from fundgame_812.fundgame.dbo.gameuser
posted @ 2007-11-12 16:29 XiaoShan 阅读(46) 评论(0) 编辑
