• I tried this...

    sp_dropserver 'SQL5-SVR'

    go

    sp_addserver 'SQL-SRV', LOCAL

    go

    but when i run this...

    select @@SERVERNAME

    it still gives the wrong name (SQL5-SVR)

    ???