Changing servername in SQL server

Last Post 06 Nov 2010 08:01 AM by russellb. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
maltesedba
New Member
New Member

--
05 Nov 2010 02:24 PM
Is it possible to make the servername an alias to the server? 
Currrently when running query select @@servername the old server name appears not the current server name. This is because the server was rebuilt as a Vmware box. I know I can replace the servername with the real, current one BUT instead of replacing the old server name with the current one , can you instead put an alias to the current server as the server name?
 
I have a user that has many stored procedures that use the old server name in cross server joins. This is also an alias to the current server name. 

Thanks,
Steve Bajada
russellb
New Member
New Member

--
06 Nov 2010 08:01 AM
you can do this in active directory, sql configuration manager, or rename the linked server on the client side


Acceptable Use Policy
---