Query between servers

[Fábio Pinheiro]

How I do a query between two sql servers, using linkedservers, but not
using openquery statement.

I think in something like this

select * from server1.database1.dbo.table

It's possible ?

[Pace]

Yes its possible, as long as you use fully qualified names.

So

SELECT
*
FROM
server.database.owner.table
WHERE
server.database.owner.table

etc

[pradeep nair]

You Can do following statements To retrieve the results from different servers

Syntax

Select *
From [server name.][database name.][owner name.][Table Name]
Where [server name.][database name.][owner name.][Table Name.][Column Name]=Value
 

Ex

Select *
From Main-Server.purchase.dbo.tbl_purchases

 

Here, Main-Server is sql server name

         purchase is database name

         dbo is database owner name

         tbl_purchases is the table name

--
Pradeep P
Mob:9900149509