January 4, 2008 at 6:29 pm
Thanks for all your help.... any suggestions will be greatly appreciated... hers the situation
Win 2k3 ...SQL 2k Sp 4 plenty ram...much much space
Ok the situation seems simple.... trying to add and drop the server name AFTER a rename on the windows side.. i have done this many many times with never a problem.
sp_dropserver 'blah blah'
go
sp_addserver 'new','local'
go
what i get is this...servername already exists....(its not on the network as any other name and should not matter)
anyways i have rebooted after each statement... and still the same.... the only good thing is this..i can rename to ANYthing but the name of the server....which is what i want.
i have also tried sp_addserver 'new','local','duplicate_Ok' and this dont error out but the server never picks up the name after the stop and start of services or reboot..so the name is stuck at Null currently... ANY help is appreciated
Thanks
DHeath
January 4, 2008 at 8:32 pm
Look in sysservers. What's in there?
January 4, 2008 at 9:28 pm
yes ...when looking in sysservers it is the second entry..
DHeath
January 8, 2008 at 4:37 pm
Thanks for the help..got the server to work thru the use of the ip address.... the name is still showing null when i use @@servername ... 🙁 but when i look in sysservers this is what i get The
srvname is SSU-PSCHME.SCS.AGENT.COM,1932\PSCHOME
inside the sysservers this is the first entry... is there a certain way to completely clear out the sysservers table so i dont crash my instance. Not sure if trucatng or deleting the enty will be best.. just wanting a lil input... or will just doing the sp_dropserver [SSU-PSCHOME.SCS.AGILENT.COM,1932\PSCHOME] be ok?
Thanks
Darryl
DHeath
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply