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
<[table]
wrong syntax"post-lesson" itemsprop = "text">
SELECT * to [server]. [Databases]. [Scheme]. [Table]
This works for me
Comments
Post a Comment