hostname change and MS SQL

We have had to change the hostname on an SQL server (Blade and the blade
moved chassis so name changed)
was called blade-0-1-5 and is now blade-0-0-12
It seems i need to run 2 stored procedures which are
sp_dropserver 'blade-0-1-5', 'droplogins'
go
sp_addserver 'blade-0-0-12', 'local'
go
Assuming this is right I cannot find anyway to run these stored procedures
is there seems to be no interactive SQL.
Help please
Gary
Hi,
(Please do not cross post)
Execute the statement in Query analyzer if SQL SERVER is normal edition , if
it is MSDE from command prompt execute
OSQL -Sserver -Usa -Ppassword
1> sp_dropserver 'old_server_name',
2> go
1> sp_addserver 'new_server_name', 'local'
2>go
For Other editions execute the below command from query Analyzer (Select it
from SQL server program groups)
sp_dropserver 'old_server_name',
go
sp_addserver 'new_server_name', 'local'
Note:
sp_dropserver 'Old_server', 'droplogins'
This removes the remote server old_server and all associated remote logins
from the local SQL Server. But in your case
u have remove the local server and add a new one.
Thanks
Hari
MCDBA
"Gary" <reachus@.netlink.info> wrote in message
news:Pycnc.8795$nN6.2020@.lakeread06...
> We have had to change the hostname on an SQL server (Blade and the blade
> moved chassis so name changed)
> was called blade-0-1-5 and is now blade-0-0-12
> It seems i need to run 2 stored procedures which are
> sp_dropserver 'blade-0-1-5', 'droplogins'
> go
> sp_addserver 'blade-0-0-12', 'local'
> go
> Assuming this is right I cannot find anyway to run these stored procedures
> is there seems to be no interactive SQL.
> Help please
> Gary
>