Instance name vs servername

#1

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?

Thanks

#2

(jantaneey (AT) gmail (DOT) com) writes:

Quote:

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, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#3

On Dec 29, 12:55*pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:

Quote:

*(jantan... (AT) gmail (DOT) 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... (AT) sommarskog (DOT) 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?

#4

(jantaneey (AT) gmail (DOT) com) writes:

Quote:

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

I don't what possible performance problems you have experienced, or how
you use @@servername, so I cannot really comment.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Instance name vs servername

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Instance name vs servername - 12-29-2007 , 11:29 AM

Re: Instance name vs servername - 12-29-2007 , 12:55 PM

Re: Instance name vs servername - 12-29-2007 , 02:06 PM

Re: Instance name vs servername - 12-29-2007 , 05:18 PM