I'm trying to determine if there's a way to get a server's alias programmatically?
Scenario: Using SQL Configuration Manager, I've created an alias for the server FQDN\InstanceName as "Murphy". All well and good.
Now, let's say I'm connected to Murphy. When I select @@SERVERNAME and SERVERPROPERTY('ServerName'), I get FQDN\InstanceName
exec sp_dropserver " FQDN\InstanceName"
sp_addserver "Murphy", 'local'
But @@SERVERNAME and SERVERPROPERTY('ServerName') both still return FQDN\InstanceName
I need to do stuff like IF <localservername> = "MURPHY" ...
We're about to get a whole bunch of new servers, and I've realized that I want to never again have to go through all the code and replace the hard coded machine / FQDNs with new ones, when all I should have to do is keep the aliases on the new machines.
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Hmmm... my OP had appeared to time-out without posting, which is why I reposted the question.
The solution was to restart the SQL Server service.
This is a change that requires a restart for the service. Glad you got it working.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)