SQL server linked servers help

mcw92

I have an exam tomorrow and have a sample question I can't answer.
Can someone help please

Its stating there is a linked server in Australia called melbourne' which is linked to a local one called Sligo. Which code would be best to get a query to execute on it.

SELECT *
FROM OPENROWSET ([MELBOURNE])
, 'SELECT * FROM
product_tbl

OR

SELECT *
FROM OPENQUERY ([MELBOURNE])
, 'SELECT * FROM
product_tbl

OR

' SELECT * FROM product_tbl')
In (OPENQUERY([MELBOURNE])


Any help would be greatly appreciated thanks.

GavMan

Think your 2nd query is closest of the 3.

Its been a while but I think it should be something like:

SELECT * FROM OPENQUERY (MELBOURNE, 'SELECT * FROM product_tbl')

Boskowski

Neither of the three.

OpenRowSet , OpenDataSource and the like are for situations where no linked server setup exists.
Typically these statements include all the credentials to query the database, like servername, username, password etc.

When querying a linked server you simply use the fully qualified name, for example:

select * from [melbourne].[mydatabase].[dbo].[product_tbl]

On top of the linked server setup you need to make sure your database user & password are lined up too.

Of course this is too late for your exam and you probably know the answer by now, but wanted to post for everyones benefit anyway.