Alternative for @@REMSERVER

Question

Alternative for @@REMSERVER

SQLZealots 276

Anyone is aware of alternative for @@REMSERVER global variable?

0 comments

Answer accepted by question author

Erland Sommarskog 138.3K MVP Volunteer Moderator

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 points

2021-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? :)
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator

2021-05-23T09:57:48.46+00:00

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.

1 additional answer

Your answer

SQLZealots 276 Reputation points

2021-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? :)
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator

2021-05-23T09:57:48.46+00:00

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.

Answer 1

Erland Sommarskog 138.3K MVP Volunteer Moderator

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.

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?