computer name

If I change the name of my computer/server will it change the name of
my sql instance?"Vincent Jones" <vncntj@.hotmail.com> wrote in message
news:ba2a2d30.0308140546.16580e6c@.posting.google.c om...
> If I change the name of my computer/server will it change the name of
> my sql instance?

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|||vncntj@.hotmail.com (Vincent Jones) wrote in message news:<ba2a2d30.0308140546.16580e6c@.posting.google.com>...
> If I change the name of my computer/server will it change the name of
> my sql instance?

A quick search in BOL under 'computer names' will reveal all

Dave