|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Renaming the server name? How could I do such thing?Dear all,
I would need to rename the name of the server. any comments will be welcomed. -- current location: alicante (es) Renaming the server is done at the OS level, System Properties, Computer
Name It may affect the SQL installation. The things that might break include replication, linked servers and master jobs. To reset the relevant row in master..sysservers use: Use Master go Sp_DropServer 'OldName' GO Use Master go Sp_Addserver 'NewName', 'local' GO Stop and Start SQL Services At this stage, select @@SERVERNAME and select SERVERPROPERTY('ServerName') should give the same value. -- Show quoteHTH. Ryan "Enric" <En***@discussions.microsoft.com> wrote in message news:14EAC2BB-A01C-4FAD-932B-E3C7B497F731@microsoft.com... > Dear all, > > I would need to rename the name of the server. > any comments will be welcomed. > -- > current location: alicante (es) BUG: "Renaming A Server" Topic in SQL Server Books Online is Incomplete
http://support.microsoft.com/kb/303774/en-us -- Show quoteHTH. Ryan "Enric" <En***@discussions.microsoft.com> wrote in message news:14EAC2BB-A01C-4FAD-932B-E3C7B497F731@microsoft.com... > Dear all, > > I would need to rename the name of the server. > any comments will be welcomed. > -- > current location: alicante (es)
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Show quote
Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Ryan" <Ryan_Waight@nospam.hotmail.com> wrote in message
news:OgvDCmkLGHA.3260@TK2MSFTNGP11.phx.gbl... > BUG: "Renaming A Server" Topic in SQL Server Books Online is Incomplete > > http://support.microsoft.com/kb/303774/en-us > > -- > HTH. Ryan > > > "Enric" <En***@discussions.microsoft.com> wrote in message > news:14EAC2BB-A01C-4FAD-932B-E3C7B497F731@microsoft.com... >> Dear all, >> >> I would need to rename the name of the server. >> any comments will be welcomed. >> -- >> current location: alicante (es) > > |
|||||||||||||||||||||||