If I change the name of my computer/server will it change the name of
my sql instance?
my sql instance?
-
-
Re: computer name
"Vincent Jones" <vncntj@hotmail .com> wrote in message
news:ba2a2d30.0 308140546.16580 e6c@posting.goo gle.com...[color=blue]
> If I change the name of my computer/server will it change the name of
> my sql instance?[/color]
After renaming the server you need to do this in SQL Server:
exec sp_dropserver 'OldServerName'
exec sp_addserver 'NewServerName' , 'local'
See "Renaming a Server" in Books Online for more details.
Simon
-
Re: computer name
vncntj@hotmail. com (Vincent Jones) wrote in message news:<ba2a2d30. 0308140546.1658 0e6c@posting.go ogle.com>...[color=blue]
> If I change the name of my computer/server will it change the name of
> my sql instance?[/color]
A quick search in BOL under 'computer names' will reveal all
Dave
Comment
Comment