Querying a linked sql server

Question

I added a linked server  which is showing in the linked server list  but when I query it  it throws an error with the db server name    EXEC sp helpserver EXEC sp addlinkedserver  aa-db-dev01  Select   from openquery  aa-db-dev01   Select   from TestDB dbo users        Msg 102  Level 15  State 1  Line 1   Incorrect syntax near  aa-db-dev01

User · Answer

If linked server name is IP address following code is true   select   from  1 2 3 4 1433 MSSQLSERVER  test dbo Table1   It s just  note    around IP address section

User · Answer

try Select   from openquery  aa-db-dev01   Select   from users    the database connection should be defined in he linked server configuration

User · Answer

You need to remove the quote marks from around the name of the linked server  It should be like this   Select   from openquery aa-db-dev01  Select   from TestDB dbo users

User · Answer

You can use   SELECT   FROM  aa-db-dev01   TestDB   dbo   users

User · Answer

The accepted answer works for me   Also  in MSSQLMS  you can browse the tree in the Object Explorer to the table you want to query    Server  -  Server Objects -  Linked Servers -   Linked server  -  Catalogs -   Database  -   table    then Right click  Script Table as  SELECT To  New Query Window  And the query will be generated for you with the right FROM  which you can use in your JOIN

User · Answer

try Select   from openquery  aa-db-dev01   Select   from users    the database connection should be defined in he linked server configuration

User · Answer

SELECT   FROM  server   database   schema   table    This works for me  SSMS intellisense may still underline this as a syntax error  but it should work if your linked server is configured and your query is otherwise correct

User · Answer

If linked server name is IP address following code is true   select   from  1 2 3 4 1433 MSSQLSERVER  test dbo Table1   It s just  note    around IP address section

User · Answer

I use open query to perform this task like so   select top 1   INTO  DATABASE TO INSERT INTO   dbo   TABLE TO SELECT INTO  from openquery       LINKED SERVER NAME        select   from  DATABASE ON LINKED SERVER   dbo   TABLE TO SELECT FROM       The example above uses open query to select data from a database on a linked server into a database of your choosing   Note  For completeness of reference  you may perform a simple select like so   select top 1   from openquery       LINKED SERVER NAME        select   from  DATABASE ON LINKED SERVER   dbo   TABLE TO SELECT FROM

User · Answer

You need to remove the quote marks from around the name of the linked server  It should be like this   Select   from openquery aa-db-dev01  Select   from TestDB dbo users

User · Answer

SELECT   FROM  server   database   schema   table    This works for me  SSMS intellisense may still underline this as a syntax error  but it should work if your linked server is configured and your query is otherwise correct

User · Answer

The accepted answer works for me   Also  in MSSQLMS  you can browse the tree in the Object Explorer to the table you want to query    Server  -  Server Objects -  Linked Servers -   Linked server  -  Catalogs -   Database  -   table    then Right click  Script Table as  SELECT To  New Query Window  And the query will be generated for you with the right FROM  which you can use in your JOIN

User · Answer

You can use   SELECT   FROM  aa-db-dev01   TestDB   dbo   users

User · Answer

I use open query to perform this task like so   select top 1   INTO  DATABASE TO INSERT INTO   dbo   TABLE TO SELECT INTO  from openquery       LINKED SERVER NAME        select   from  DATABASE ON LINKED SERVER   dbo   TABLE TO SELECT FROM       The example above uses open query to select data from a database on a linked server into a database of your choosing   Note  For completeness of reference  you may perform a simple select like so   select top 1   from openquery       LINKED SERVER NAME        select   from  DATABASE ON LINKED SERVER   dbo   TABLE TO SELECT FROM

User · Answer

SELECT   FROM  server   database   schema   table    This works for me  SSMS intellisense may still underline this as a syntax error  but it should work if your linked server is configured and your query is otherwise correct

User · Answer

SELECT   FROM  server   database   schema   table    This works for me  SSMS intellisense may still underline this as a syntax error  but it should work if your linked server is configured and your query is otherwise correct

[sql-server] Querying a linked sql server

Examples related to sql-server

Examples related to linked-server