Is this a bad idea? sp_addserver 'namedInstanceAlias'

• Jared

  SSC Guru

  Points: 61793

  More actions

  September 24, 2012 at 2:49 pm

  #262049

  So, we have a situation where we had to add a named instance, but set up a DNS alias to allow developers to connect to it via the alias; i.e. serverNameame is referenced as name.

  In order to make this easier to manage, one individual used the drop/add server procs to drop the serverNameame server and add "name." So now, when we query sys.servers or @@servername, it does not return the servernameame, but simply "name" for this named instance. Is this going to cause us problems?

  Jared
  CE - Microsoft

• Jared

  SSC Guru

  Points: 61793

  More actions

  September 25, 2012 at 6:29 am

  #1541810

  Since nobody has any info, am I to assume that this will not cause any problems? (I already know, assuming anything makes an...) Any thoughts? Do I need to explain better?

  Jared
  CE - Microsoft

• sestell1

  SSChampion

  Points: 10230

  More actions

  September 25, 2012 at 9:05 am

  #1541926

  Interesting! I have no idea, as I've never seen anyone try to do this before. I'd guess if things like the job agent work alright then it should be ok... :unsure: