|
Comments
|
|
Good to know
|
|
|
I tried serverproperty function for my local machin and its giving me result NULL?
|
|
|
Shimple and besht, Ke@p tit tup.
|
|
|
Good to know. I want the absolute most reliable way and will use this approach.
|
|
|
Good little bit of info about the rename
|
|
Andrew Meyer on
2/18/2010
Wouldn't the 'ServerName' property of the serverproperty function be more equivalent to @@ServerName? Or does this suffer the same problem on a server rename? Or was the initial objective to get the actual server name, not the instance name?
|
|
|
Mention of InstanceName would have completed the concept.
|
|
|
Excellent, as always.
|
|
|
I also tried the serverproperty function on all my 2005 SQL Server boxes and they are all returning NULL?
|
|
Martin Miller on
2/18/2010
Thanks Andy.
-Martin
|
|
|
Real good... really refreshes the basics
|
|
|
Excellent quality...
|
|
|
i like a very short video mixed in every few days.
|
|
|
Information is great
|
|
|
This was a small but very important piece of information. Thanks
|
|
|
that's fine
|
|
|
MachineName won't return your Cluster name.
|
|
|
Good video
|
|
|
One thing you should note is that the @@ServerName will return the MachineName and the instance. SELECT SERVERPROPERTY('ServerName'); might be a little closer to @@SERVERNAME.
Rick
|