建数据库连接服务器

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-12-07 11:16  zhangh  阅读(198)  评论(0)    收藏  举报