• I did only sp_dropserver 'FIRSTNAME'

    and sp_addserver 'SECONDNAME', LOCAL.

    Nothing else.

    I wonder where serverproperty('servername') gather information