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
Printable View
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
[QUOTE=boreddy;29160]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[/QUOTE]
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
[I]Mark it as Thank if u found the answer useful[/I] :)
You need to establish the link first between both the servers.
How to link between servers
follow this [URL="http://www.databasejournal.com/features/mssql/article.php/3116011"]link[/URL]