Rename a server in SQL 2005

  • I have a server with SQL 2005 that I want to rename it. Let's say the server name is OldServer and I want to rename it to NewServer. So here is what I did:

    sp_dropserver 'OldServer'

    sp_addserver 'NewServer', 'local'

    restart SQL Server service

    After SQL Server is started, Sysservers table looks fine but the column IsRemote=1. Shouldn't it be zero ? Should I be concerned about it ? Please help.

    Thanks in advance,

    Jimmy

  • I've got a server that I do that with every week and IsRemote is always 1 and it works just fine.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • Thanks for the reply. Is anybody else have to say about this ?

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

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