RE: Renaming the SQL Server PC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Aleksandar Grbic (AleksandarGrbic_at_discussions.microsoft.com)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 05:43:08 -0800

exec sp_dropserver 'servername'
exec sp_addserver 'newservername', 'local'

rename pc and restart

"Brian" wrote:

> I have to re-name the PC that I have SQL Server running on, the SQL instance
> has the same name as the PC, will I have to rename the SQL instance also?
>
> Thanks,
> Brian
>
>
>

Relevant Pages

  • Re: Rename Recorded TV
    ... the audio portion of the recorded TV did play. ... > Brian wrote: ... >> Is there a way for non programers like me to rename a file? ... >> simply allow me to rename my TV shows I am off loading from my Ultimate TV, ...
    (microsoft.public.windows.mediacenter)
  • Re: Screen Saver
    ... Copy ssmypics.sc_ from the i386 folder on the XP CD to the desktop. ... Rename the file to ssmypics.scr. ... Right click the file and click Install. ... Brian A. Sesko ...
    (microsoft.public.windowsxp.customize)
  • RE: choosing the correct attachment
    ... >>> and then the next time through attach the html doc. ... I also took out Filename => $_ I didn't need to rename the file. ... >>> Brian Volk ...
    (perl.beginners)
  • RE: Space bar, period, comma quit working in Word 2003
    ... There were no add-ins, but I did rename ... You could also rename your normal.dot file to normal.bak in windows explorer ... Brian McCaffery ... "Joy" wrote: ...
    (microsoft.public.word.application.errors)
  • Re: Rename Recorded TV
    ... You should be able to use Windows Media Player 10 to rename your files. ... Brian wrote: ... > Is there a way for non programers like me to rename a file? ...
    (microsoft.public.windows.mediacenter)