Hi i have two server on the main server and on the main server i have 2 databases.
I create a link in another server to the main server and the connections is ok.
but this connection works well in database "1" on the main server, but when try to get info for the database "2"
i see the follow error
Msg 7314, Level 16, State 1, Procedure vw_sales_actuals, Line 5
The OLE DB provider "SQLNCLI10" for linked server "MZMAS235\SQL1" does not contain the table ""EncoreCompanyM"."dbo"."vw_daily_sales"". The table either does not exist or the current user does not have permissions on that table.