Hostname change and SQL

[Gary]

We have had to change the hostname on an SQL server (Blade and the blade
moved chassis so name changed)

was 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
as there seems ot be no interactiove SQL.

Help please

Gary

[bobb]

This is for MYSQL, not MS-SQL...
if it's any consulation, this wouldn't be a problem with MYSQL.
Also, I do know since MS-SQL v6 there's a need to change parms inside of
enterprise manager.
good luck

"Gary" <re*****@netlink.info> wrote in message
news:bvcnc.8783$nN6.5125@lakeread06...

We have had to change the hostname on an SQL server (Blade and the blade
moved chassis so name changed)

was 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
as there seems ot be no interactiove SQL.

Help please

Gary

[bobb]

This is for MYSQL, not MS-SQL...
if it's any consulation, this wouldn't be a problem with MYSQL.
Also, I do know since MS-SQL v6 there's a need to change parms inside of
enterprise manager.
good luck

"Gary" <re*****@netlink.info> wrote in message
news:bvcnc.8783$nN6.5125@lakeread06...

We have had to change the hostname on an SQL server (Blade and the blade
moved chassis so name changed)

was 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
as there seems ot be no interactiove SQL.

Help please

Gary