Posted by Erland Sommarskog on 06/02/05 23:47

(andyjgw@gmail.com) writes:
> @@servername is fine, though I'd suspect it may be dynamic enough to
> query the machine rather than a value stored in the DB somewhere?

No, I think it digs it out of the registry at startup. It's not
an uncommon problem that @@servername gets messed up, if you rename
the Windows name, or move the installation from one box to another
box with a different name.

Also, reading it from Windows wouldn't do on a cluster, and then you
have named instances where the servername is XXX\INSTANCE_NAME.

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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Code in the database or middle tier (the CLR controversy)
• Prev in forum: Re: SQL Connections with VB.NET
• Thread view: Re: SQL server - 'cold' database clone, was this ok?

[Reply to this message]