链结服务器的难题!!!!
lwwxf 2003-08-20 11:30:14 建连接服务器如何指定IP地址
sp_addlinkedserver [ @server = ] 'server'
[ , [ @srvproduct = ] 'product_name' ]
[ , [ @provider = ] 'provider_name' ]
[ , [ @datasrc = ] 'data_source' ]
[ , [ @location = ] 'location' ]
[ , [ @provstr = ] 'provider_string' ]
[ , [ @catalog = ] 'catalog' ]
要求
其中@srvproduct = 'SQL SERVER'
@provider = 'SQLOLEDB'
@datasrc = '指定的IP'
希望各位高手百忙之中就就老弟吧