-
Erland Sommarskog 72,416 Reputation points MVP2021-05-22T17:18:24.167+00:00 There are no alternatives. All you see on that page is dead functionality, and earlier this afternoon I submitted feedback on that topic that should wipe out that text and say that the function always returns NULL.
-
SQLZealots 276 Reputation points2021-05-23T04:07:57.497+00:00 Great and thank you! Appreciate if you can share the feedback link here so I can vote for it too? :)
Sign in to comment1 additional answer
Sort by: Most helpful
-
Erland Sommarskog 72,416 Reputation points MVP
2021-05-22T10:23:06.35+00:00 What more precisely do you have in mind? This function relates to functionality that retains to remote servers, a functionality that has been discontinued. Since there cannot be any remote server, the function always return NULL.
Sign in to answer-
SQLZealots 276 Reputation points
2021-05-22T13:52:13.1+00:00 Thanks for your reply. MS doc has a real time scenario https://learn.microsoft.com/en-us/sql/t-sql/functions/remserver-transact-sql?view=sql-server-ver15
I would like to understand if @@REMSERVER is a deprectaed one, then What is the alternative to get this data as such in the example given. Dec says, we should use linked server procs, but I could not get that part . Can you help me with exact replacement T SQL for @@REMSERVE, Does it makes sense?
Sign in to comment -
-
Alternative for @@REMSERVER
SQLZealots
276
Reputation points
Anyone is aware of alternative for @@REMSERVER global variable?
Accepted answer
https://github.com/MicrosoftDocs/sql-docs/issues/6434
These days, Microsoft have their documentation as open source on Github, and you can go there to file issues. It seems that you need to have a Github account to do this.