Hi:

SQL2005 ent sp3 with win ent 2003.
Server Name is changed, from A to B, but linked side still using A. In sql 2000, I could change the syserver table. But in SQL2005, is there a way to change the servername instead of reinstall SQL2005? I don't want to use the alias for linking.

update sys.servers
set name = 'BBBBB'
where name = 'AAAAA'

Msg 259, Level 16, State 1, Line 1
Ad hoc updates to system catalogs are not allowed.

thanks
David