Posted by Erland Sommarskog on 03/11/06 22:43

Frank Bishop (fbishop@viper.com) writes:
> I have a local install of MSDE on my workstation. I have also defined a
> linked server with another SQL Server on our network. I accepted all the
> defaults when I installed MSDE and the server got named my machine name.
> Everything is working great.
>
> Our IT department now needs to change my machine name. What effect will
> this have on my current SQL installation?

If memory serves, the server name changes automatically. However,
@@servername usually gets messed up.

To this end to:

exec sp_dropserver 'oldname'
exec sp_addserver 'newname', 'local'

Then stop and restart SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Getting list of recently added IDENTITY items
• Prev in forum: Re: Execution Plan Hinting
• Thread view: Re: Changing Machine Names MSDE

[Reply to this message]