Querying linked servers

Question

Querying linked servers

Steve Jones - SSC Editor

SSC Guru

Points: 736479
More actions
April 2, 2016 at 1:27 pm

#74807

Comments posted to this topic are about the item Querying linked servers
April 4, 2016 at 1:55 am

This was removed by the editor as SPAM

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 1

I have used rarely OPENQUERY and linked servers since the release of SQL Server 2008 but it is maybe the only thing I remember ( OPENQUERY ) , so the answer was evident ( I am not using it because I got many problems with the linked servers ).

Anyway , thanks for this interesting question about which I had to think during 5 minutes.

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 2

Nice question, thanks for sharing it.

I am curious if I can make a synonym for an object on a linked server.

Any idea ?

Joel Ewald SSCertifiable Points: 6120 More actions · Answer 3

And if you have a linked server connecting to Oracle

CREATE SYNONYM [dbo].[TestSynonym] FOR [TestLinkedServer]..[Workspace].[TableName]

GO

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

A nice and simple question to start the week. Thanks, Steve.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 5

Joel Ewald (4/4/2016)
And if you have a linked server connecting to Oracle
CREATE SYNONYM [dbo].[TestSynonym] FOR [TestLinkedServer]..[Workspace].[TableName]
GO

Thanks a lot Joel, good spot. Connecting to other db provider as it would be local. I wander if it accepts T-SQL or PL-SQL.

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 6

Stewart "Arturius" Campbell (4/4/2016)
Good question, thanks Steve
Iulian -207023 (4/4/2016)
Nice question, thanks for sharing it.
I am curious if I can make a synonym for an object on a linked server.
Any idea ?
try this:
CREATE SYNONYM [dbo].[TestSynonym] FOR [TestLinkedServer].[Testing].[TEST].[GetMulti]
GO
(substituting your own linked server name, database, schema & table/view/Table Valued function, of course)

Thank you Stewart, will try it.