Querying a linked sql server -


I have added a linked server, which is showing in the linked server list, but when I ask it This throws an error in the name of the DB server

  EXEC sp_helpserver EXEC sp_addlinkedserver 'aa-db-dev01' Choose from the Open Query * ('AA-DB-dev01', 'TestDB.dbo.users Wrong syntax near 'aa-db-dev01' -   

Message 102, level 15, state1, line 1
wrong syntax

<[table] "post-lesson" itemsprop = "text">
  SELECT * to [server]. [Databases]. [Scheme]. [Table]  

This works for me


Comments