July 25, 2002 at 8:25 am
Have had a SQL Server 6.5 running happily here for some time. However, due to some network problems the machine name has had to have been changed. I checked @@servername and as expected it reports the old server name.
Apart from any client apps that connect natively by name, is there anything else this could effect??
Cheers,
Andy.
July 25, 2002 at 6:24 pm
Take a look here, I believe if not the same in 6.5 then there is something similar. http://www.sqlservercentral.com/columnists/bknight/renameserver.asp
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 26, 2002 at 11:51 am
sp_dropserver, sp_addserver should work.
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply