多想想，总能感悟出什么...

建数据库连接服务器

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) 编辑