question

SQLZealots avatar image
0 Votes"
SQLZealots asked ·

Alternative for @@REMSERVER

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

sql-server-transact-sql
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ·

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.

· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Great and thank you! Appreciate if you can share the feedback link here so I can vote for it too? :)

0 Votes 0 ·

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 Vote 1 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ·

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.

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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?

0 Votes 0 ·