Menu
The following query has a red squiggly underlining for the server through to the table this bit [OtherServer].[UAT_DB].[dbo].[profileTable] and when hovering says Invalid Object Name, but interestingly if I execute the line it returns the correct records from the linked server table:-
select * from [OtherServer].[UAT_DB].[dbo].[profileTable]
654
This typically means 1 of 2 things... you've referenced an object (table, trigger, stored procedure,etc) that doesn't actually exist (i.e., you executed a query to update a table, and that table doesn't exist). Or, the table exists, but you didn't reference it correctly...
1 Open SQL Server Management Studio, navigate to the Object Explorer pane, and select Server Objects > Linked servers > Providers. 2 Right-click mrOledb. Provider and select Properties. 3 Select allow in process, and then click OK.
Go to start-administrative tools and open the data sources(odbc) then click on system dsn, here you will find the linked server dsn name. From here you can edit the properties of linked server. You can also test the connection.
Refreshing the local intellisense cache might fix it.
Whilst in a query window, either:
51
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
