Post reply

Is this a bad idea? sp_addserver 'namedInstanceAlias'

  • 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

  • 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

  • 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:

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply