prob with sql

Dear all,
i have server wihch is running sql server
and users are using it .
now i want to change
the server name . if i change server name
sql server name will remain or not ?
if it remains then how can i change it ?
coz users regiseter it by name ..
any help will be appreicated .......

Hi

If you change the network name of the server, sql server will need to be
updated by
dropping the old server and re-adding the new one. Try something like the
following using Query Analyser on the server:

DECLARE @server  sysname,	@newservern
ame sysname

SELECT @server = @@SERVERNAME, @newservername = HOST_NAME()
SELECT @@SERVERNAME AS [Old Server Name]

EXEC ( 'sp_dropserver ' + @server )

EXEC ( 'sp_addserver ' + @newservername + ', local' )
GO

SELECT @@SERVERNAME AS [New Server Name]

John

"Vivek" wrote:

> Dear all,
>              i have server wihch is running sql server
>              and users are using it .
>                                             now i want to change
>               the server name . if i change server name
>               sql server name will remain or not ?
>                if it remains then how can i change it ?
>                coz users regiseter it by name ..
>                 any help will be appreicated .......
>
>
>

Hi,
I u will change the name of the registration name of the sql srever
then it will not effect . but if u have created a linked server then u
have to drop  it and recreate it again.

from
sufian


John Bell  wrote:[color=darkred
]
> Hi
>
> If you change the network name of the server, sql server will need to be
> updated by
> dropping the old server and re-adding the new one. Try something like the
> following using Query Analyser on the server:
>
> DECLARE @server  sysname,	@newservern
ame sysname
>
> SELECT @server = @@SERVERNAME, @newservername = HOST_NAME()
> SELECT @@SERVERNAME AS [Old Server Name]
>
> EXEC ( 'sp_dropserver ' + @server )
>
> EXEC ( 'sp_addserver ' + @newservername + ', local' )
> GO
>
> SELECT @@SERVERNAME AS [New Server Name]
>
> John
>
> "Vivek" wrote:
>