Viewing 3 posts - 1 through 3 (of 3 total)
HI ANy body Help me update statement on Linked diff Servers
It working fine on Selecect statement but Update can not
Update OPENQUERY([112.137.162.205], 'select * from [CCRSVTEam]..[tbl_SvDetails]') set dbs_UpdatedStatus = A.dbs_UpdatedStatus
from tbl_SvDetails...
March 11, 2010 at 8:25 pm
Thanks for immediate response.
its working good.I found two solutions
exec sp_serveroption @server='202.190.199.69', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='202.190.199.69', @optname='rpc out', @optvalue='true'
Sol1:
exec [202.190.199.69].[CCRSVTEAM202].dbo.sp_executesql N'select * from tbl_SvDetails'
Sol2:
SELECT * FROM...
March 10, 2010 at 6:56 pm
select * from [112.137.162.205].[CCRSVTEAM]..[dbo.tbl_SvDetails]
OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='112.137.162.205', TableName='"CCRSVTEAM"."dbo.tbl_SvDetails"'].
Msg 7314, Level 16, State 1, Line 1
OLE DB provider '112.137.162.205'...
March 9, 2010 at 8:26 pm
Viewing 3 posts - 1 through 3 (of 3 total)