为什么我通过链接服务器归档数据时出现以下错误？ [英] Why I am getting below error on archiving data via linked server?

问题描述

通过链接服务器运行存档脚本时出现以下错误



无法找到对象CorporateAccountDetails，因为它不存在或您没有权限。 />


Live DB和Archival DB中都有该表。链接服务器名称为TEST-319E，模式名称为dbo。实时数据库是NWPSCS_DIB_TEST&档案数据库是NWPSCS_DIB_ARCHIVAL_TEST。



以下是我的档案查询

  INSERT   INTO  [TEST-319E]。[NWPSCS_DIB_ARCHIVAL_TEST] .dbo.CorporateAccountDetails（CorporateId，AccountNo）
  SELECT  CorporateId，AccountNo  FROM  NWPSCS_DIB_TEST.dbo.CorporateAccountDetails 

我尝试过：



以下是我的档案查询

  INSERT   INTO  [TEST-319E]。[NWPSCS_DIB_ARCHIVAL_TEST] .dbo.CorporateAccountDetails（CorporateId， AccountNo）
  SELECT  CorporateId，AccountNo  FROM  NWPSCS_DIB_TEST.dbo.CorporateAccountDetails 

解决方案

我试过并为我工作..请检查配置设置并尝试。

I am getting below error on running Archival script via Linked Server

Cannot find the object CorporateAccountDetails because it does not exist or you do not have permissions.

The table is there in both Live DB and Archival DB.The Linked server Name is TEST-319E and schema name dbo . Live DB is NWPSCS_DIB_TEST & Archival DB is NWPSCS_DIB_ARCHIVAL_TEST.

Below is my Archival Query

INSERT INTO [TEST-319E].[NWPSCS_DIB_ARCHIVAL_TEST].dbo.CorporateAccountDetails(CorporateId,AccountNo)                            
   SELECT CorporateId,AccountNo FROM  NWPSCS_DIB_TEST.dbo.CorporateAccountDetails

What I have tried:

Below is my Archival Query

INSERT INTO [TEST-319E].[NWPSCS_DIB_ARCHIVAL_TEST].dbo.CorporateAccountDetails(CorporateId,AccountNo)                            
   SELECT CorporateId,AccountNo FROM  NWPSCS_DIB_TEST.dbo.CorporateAccountDetails

解决方案

I have tried and working for me..Kindly check the configuration settings and try.

这篇关于为什么我通过链接服务器归档数据时出现以下错误？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！