|
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
[Back to original message]
|