Thread: Database Access

I have two servers both servers have some databases
if i want to access from one server database table to other server database table
how it possible in SQL Server

Originally Posted by boreddy

I have two servers both servers have some databases
if i want to access from one server database table to other server database table
how it possible in SQL Server

hi reddy,

u can use the following query

SELECT * FROM [DatabaseName].[OwnerName].[TableName]

[DatabaseName] - Name of the database in which table exists
[OwnerName] - Name of the target database owner
[TableName] - Name of the table

---V V---
Vikas Vaidya
Mark it as Thank if u found the answer useful

You need to establish the link first between both the servers.

How to link between servers

follow this link