Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connection to a server using Select
- Thread starter ab1011
- Start date
You need to create a Linked Server on Server A to Server B.
Its under Security in EM (Enterprise Manager).
Or if you want the T-SQL way:
EXEC sp_addlinkedserver SERVER_B, N'SQL Server'
EXEC sp_configure 'remote access', 1
RECONFIGURE
GO
exec sp_serveroption @server='SERVER_B', @optname='data access', @optvalue='TRUE'
go
Then you can query as follows:
select * from SERVER_B.DATABASE.OWNER.TABLE
Keep in mind you have to be an SA to set this up.
Let me know if it works out.
Mike
Its under Security in EM (Enterprise Manager).
Or if you want the T-SQL way:
EXEC sp_addlinkedserver SERVER_B, N'SQL Server'
EXEC sp_configure 'remote access', 1
RECONFIGURE
GO
exec sp_serveroption @server='SERVER_B', @optname='data access', @optvalue='TRUE'
go
Then you can query as follows:
select * from SERVER_B.DATABASE.OWNER.TABLE
Keep in mind you have to be an SA to set this up.
Let me know if it works out.
Mike
- Status
Similar threads
- Locked
- Question
- Locked
- Question