Click here to Skip to main content
14,329,627 members
Rate this:
Please Sign up or sign in to vote.
See more:
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
Posted
Updated 11-Aug-16 23:54pm

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

I have tried and working for me..Kindly check the configuration settings and try.
   
Comments
Ema112 13-Aug-16 3:47am
   
What all can in configuration settings can cause such an issue. Is it Linked server or Archival DB permission settings or access right to a table in DB that cause such an error?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100