Anyone is aware of alternative for @@REMSERVER global variable?
Anyone is aware of alternative for @@REMSERVER global variable?
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.
Great and thank you! Appreciate if you can share the feedback link here so I can vote for it too? :)
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.
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.
Thanks for your reply. MS doc has a real time scenario https://docs.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?
9 people are following this question.