Re: Hostname Change and SQL
From: Alric (news_at_tenhundfeld.org)
Date: 05/09/04
- Next message: Alan: "Re: Parameters or no parameters - CASE statements"
- Previous message: Gary: "Hostname Change and SQL"
- In reply to: Gary: "Hostname Change and SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 09 May 2004 02:03:58 -0500
Please explain how there is no interactive SQL.
Alric
Gary wrote:
> We have had to change the hostname on an SQL server (Blade and the balde
> moved chassis so name changed)
>
> It seems i need to run 2 stored procedures which are
> sp_dropserver 'old_name', 'droplogins'
> go
> sp_addserver 'new_name', '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
>
>
- Next message: Alan: "Re: Parameters or no parameters - CASE statements"
- Previous message: Gary: "Hostname Change and SQL"
- In reply to: Gary: "Hostname Change and SQL"
- Messages sorted by: [ date ] [ thread ]
Loading
