February 7, 2020 at 4:31 pm
other than named instances of SQL Server, where is the internal name of SQL used? We just discovered that a server had its internal name changed by accident a week ago, it was changed , and a normal weekly reboot caused it to take effect, It apparently didn't effect anything?
we are running a default instance of SQL Serve 2014 enterprise.
Thanks
February 7, 2020 at 8:18 pm
Some processes where there is access to other servers, external resources and some of the functions to get server name. I know Replication is one thing that uses it and you can have problems when the server has one name and a different name is in sys.servers. Whether you hit issues or not, you'd want to have the correct names in place.
Sue
February 10, 2020 at 11:11 am
a few years ago, I encountered an issue for a large retail company. Every single point of sale system stopped. the issue was that they had cloned the deployment server and sent it out everywhere - not sure how they managed to do it, but despite serverproperty('machinename') being different on every POS, @@servername was 'xxxxxx'.
needless to say anything using @@servername looked like it was from the same store and same device. and 1 cashier was logged in on every device in the estate.
now they have a little "post deployment script" - sp_dropserver, sp_addserver 'local' etc etc
MVDBA
February 11, 2020 at 5:38 am
This was removed by the editor as SPAM
February 11, 2020 at 5:39 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply