Sunday, March 11, 2012

change computer name?

hi,
I want to change the computer name. After that, the SQL server will still
work? If not, how to change the SQL Server Name?
Thanks..Yilue,
See
http://www.tkdinesh.com/faq/ans/rename.html
If this is a SQL2000, you need to change the originating_server column in
msdb..sysjobs table.Details here:
PRB: Error 14274 Occurs When You Update a SQL Agent Job After Renaming
Windows Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281642
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Y" <yilue7490@.rogers.com> wrote in message
news:%23oIilnabDHA.2308@.TK2MSFTNGP12.phx.gbl...
> hi,
> I want to change the computer name. After that, the SQL server will still
> work? If not, how to change the SQL Server Name?
> Thanks..
>

No comments:

Post a Comment