Home Forums SQL Server 2005 Administering Change company name in SQL Server 2005 RE: Change company name in SQL Server 2005

  • February 2, 2011 at 6:00 pm

    #1281684

    1) sp_dropserver 'OldServerName'

    2) sp_addserver 'NewServerName', local

    3) then Retstart mssql

    this is useful for linked server.

    ----------
    Ashish