Posted by jantaneey on 12/29/07 20:06

On Dec 29, 12:55 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
>  (jantan...@gmail.com) writes:
> > Someone renamed a server from 2A to A.
> > When I do @@servername I get 2A.
> > The server/machine name is 2.
>
> > Should my triggers say 2A or 2?  Does it matter?
>
> EXEC sp_dropserver '2A'
> EXEC sp_addserver 'A', 'local'
>
> Restart SQL Server. After this, @@servername should return the correct
> value.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thanks... Do you think have the old name will have caused performance
problems?

• Next in forum: Cascade update to two fields in a table...
• Prev in forum: Re: Database Tripled In Size!!
• Thread view: Re: Instance name vs servername

[Reply to this message]