the @@servername function returns the name of the local server running SQL Server.
is there a function or sql code that can return the server name by giving it the server ip address ?
i am on server "A" wiht ip : 18.104.22.168
server "B" with ip :22.214.171.124
i need to run on server A
a function or query giving it as parameter the ip address of a server
thats returns in our casae "B" which is the server name corresponding to ip address 126.96.36.199
thanks for ur help
If something's hard to do, then it's not worth doing.