--建立数据库连接，'test'为别名

exec sp_addlinkedserver 'test','','MSDASQL',NULL,NULL,  
     'DRIVER={SQL Server};SERVER=192.168.0.4;UID=developer;PWD=123456;'  

--数据库登录

exec sp_addlinkedsrvlogin  'test','false',null,'developer','123456'

select * from test.gvILMSClear.dbo.BasCity

--关闭数据库连接

exec sp_dropserver 'test','droplogins'