Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: how to interpret this error message

    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...

  • RE: how to interpret this error message

    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 OPENQUERY([202.190.199.69], 'select * from...

  • RE: how to interpret this error message

    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'...

Viewing 3 posts - 1 through 3 (of 3 total)