Linked Server IP Query

[Delphin]

I am trying to query a linked server and the the only properties I have is the IP address which is linked directly to the DB I have access to.

I have tried a query such as select [10.10.10.10].* from 10.10.10.10.tbl1

I know this is incorrect, but the server is linkeddirect to the DB which doesn't come up.

 

[mrdenny]

You'll need the database name of the database you are trying to get data out of. Querying data from a linked server requires the use of the full four part name.

[{ServerName}].[{database}].[{owner}].[{table}]

In this case (based on what you've provided) you'd need something like this.

select *
from [10.10.10.10].{database}.dbo.tbl1

Linked servers aren't linked directly to databases. They are linked to servers. From a linked server you can access any database on the server. When you select tables in the linked server the database that shows up is simply the default database for the account that is making the link.

To view a list of databases on the remote server try this query.

select name
from [10.10.10.10].master.dbo.sysdatabases

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)