April 2, 2016 at 1:27 pm
Comments posted to this topic are about the item Querying linked servers
April 2, 2016 at 3:10 pm
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.
April 4, 2016 at 12:57 am
Nice question, thanks for sharing it.
I am curious if I can make a synonym for an object on a linked server.
Any idea ?
April 4, 2016 at 1:55 am
This was removed by the editor as SPAM
April 4, 2016 at 5:05 am
And if you have a linked server connecting to Oracle
CREATE SYNONYM [dbo].[TestSynonym] FOR [TestLinkedServer]..[Workspace].[TableName]
GO
April 4, 2016 at 5:29 am
A nice and simple question to start the week. Thanks, Steve.
April 4, 2016 at 6:45 am
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.
April 4, 2016 at 7:28 am
Stewart "Arturius" Campbell (4/4/2016)
Good question, thanks SteveIulian -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.
April 4, 2016 at 9:29 am
thx
April 4, 2016 at 2:06 pm
April 5, 2016 at 1:55 pm
Thanks for all the info on this.
April 11, 2016 at 6:25 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy