Post reply

what is the process to change the named instance?

  • August 19, 2008 at 11:18 am

    #189501

    Hi,

    I have been already installed a named instance say ABC.It has 25 databases. But now my requirement is to change the named instance to XYZ,So how can achieve this?

  • August 19, 2008 at 11:31 am

    #860183

    If it is not a cluster you can change by following below steps:

    sp_dropserver old_name

    GO

    sp_addserver new_name, local

    GO

  • August 19, 2008 at 3:20 pm

    #860295

    It is a clusterd instance...

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

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