Linked Server and query analyzer [modified]
-
Is it possible to query the table of a remote data server (MS SQL) in "query analyzer" without using a Linked Server? What are the items that I need to setup/know in order to do that? For example: Select local.*, Rmt.* From LocalServer.LocalDatabase.dbo.Table1 local, RemoteServer.RemoteDatabase.dbo.Table2 Rmt NOTE: Query analyzer current server is “Local” -- modified at 11:52 Wednesday 13th December, 2006
-
Is it possible to query the table of a remote data server (MS SQL) in "query analyzer" without using a Linked Server? What are the items that I need to setup/know in order to do that? For example: Select local.*, Rmt.* From LocalServer.LocalDatabase.dbo.Table1 local, RemoteServer.RemoteDatabase.dbo.Table2 Rmt NOTE: Query analyzer current server is “Local” -- modified at 11:52 Wednesday 13th December, 2006
Lookup OpenRowset or OpenDataSource in Sql Books online: Here's and example
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=ServerName;User ID=MyUID;Password=MyPass'
).Northwind.dbo.CategoriesUsing the GridView is like trying to explain to someone else how to move a third person's hands in order to tie your shoelaces for you. -Chris Maunder
-
Lookup OpenRowset or OpenDataSource in Sql Books online: Here's and example
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=ServerName;User ID=MyUID;Password=MyPass'
).Northwind.dbo.CategoriesUsing the GridView is like trying to explain to someone else how to move a third person's hands in order to tie your shoelaces for you. -Chris Maunder
I spent 4 hours searching Google for this answer, you’re the man. Thanks Andy, to your time and effort to answer my question. -- modified at 20:57 Wednesday 13th December, 2006
-
Is it possible to query the table of a remote data server (MS SQL) in "query analyzer" without using a Linked Server? What are the items that I need to setup/know in order to do that? For example: Select local.*, Rmt.* From LocalServer.LocalDatabase.dbo.Table1 local, RemoteServer.RemoteDatabase.dbo.Table2 Rmt NOTE: Query analyzer current server is “Local” -- modified at 11:52 Wednesday 13th December, 2006
If it is already a linked server it is a bit simplier. select * from [server].[database].[owner].[table] In pratice this works out as Select * from [OrderServer].[orderdb]..[orders]
Blog Have I http:\\www.frankkerrigan.com