dropserver
This is a discussion on dropserver within the SQL Server forums, part of the Microsoft SQL Server category; --> We are on Sql2000 on a Win2003 server and we had to rename the machine. So I did a: ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 05:08 AM
| ||||
| ||||
 dropserver We are on Sql2000 on a Win2003 server and we had to rename the machine. So I did a: sp_dropserver xxxx then sp_addserver aaaa All appears okay execpt when I do a: select @@servername --- this is null If I do select * from sysservers the name appears.... everything things to be functioning properly... any thoughts ?      |
|
02-29-2008, 05:08 AM
| ||||
| ||||
| Re: dropserver I forgot: sp_addserver 'newname','local' sorry... "AHartman" <Hoosbruin@Kconline.com> wrote in message news:rJOdnVOLu-0oXKXcRVn-sA@kconline.com... > We are on Sql2000 on a Win2003 server and we had to rename the machine. > > So I did a: > sp_dropserver xxxx > then sp_addserver aaaa > > All appears okay execpt when I do a: > > select @@servername --- this is null > > If I do select * from sysservers the name appears.... > > everything things to be functioning properly... > > any thoughts ? > > |
Linear Mode
