Richard M (2/19/2009)
um....sp_dropserver will "remove a server from the list of known remote and linked servers on the local instance of SQL Server"..... so it will not affect at all your running instance.
when you run sp_helpserver you are getting production right?
Not sure if only the sp_addserver with the 'local' option will do the trick
You can change the Servername using sp_addserver.
Refer http://msdn.microsoft.com/en-us/library/ms143799.aspx?ppud=4