470,848 Members | 1,709 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,848 developers. It's quick & easy.

Hostname change and SQL

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
Jul 20 '05 #1
2 2050
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

Jul 20 '05 #2
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

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by mike | last post: by
1 post views Thread by Andrew Melton | last post: by
1 post views Thread by Lamis | last post: by
1 post views Thread by spride | last post: by
1 post views Thread by PaulReddin | last post: by
reply views Thread by =?ISO-8859-15?Q?=22Martin_v=2E_L=F6wis=22?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.