Is an expression that contains the property information to be returned for the server. propertyname can be one of these values.

Property name

Values returned

BuildClrVersion

Version of the Microsoft .NET Framework common language runtime (CLR) that was used while building the instance of SQL Server 2005.

Base data type: nvarchar(128).

Collation

Name of the default collation for the server.

NULL = Input is not valid, or an error.

Base data type: nvarchar(128)

CollationID

ID of the SQL Server collation.

Base data type: int

ComparisonStyle

Windows comparison style of the collation.

Base data type: int

ComputerNamePhysicalNetBIOS

NetBIOS name of the local computer on which the instance of SQL Server is currently running.

For a clustered instance of SQL Server on a failover cluster, this value changes as the instance of SQL Server fails over to other nodes in the failover cluster.

On a stand-alone instance of SQL Server, this value remains constant and returns the same value as the MachineName property.

Note:

If the instance of SQL Server is in a failover cluster and you want to obtain the name of the failover clustered instance, use the MachineName property.

NULL = Input is not valid, or an error.

Base data type: nvarchar(128)

Edition

Installed product edition of the instance of SQL Server. Use the value of this property to determine the features and the limits, such as maximum number of CPUs, that are supported by the installed product.

Returns:

'Desktop Engine' (Not available for SQL Server 2005.)

'Developer Edition'

'Enterprise Edition'

'Enterprise Evaluation Edition'

'Personal Edition'(Not available for SQL Server 2005.)

'Standard Edition'

'Express Edition'

'Express Edition with Advanced Services'

'Workgroup Edition'

'Windows Embedded SQL'

Base data type: nvarchar(128)

EditionID

Is an identification number that represents the installed product edition of the instance of SQL Server. Use the value of this property to determine features and limits, such as maximum number of CPUs that are supported by the installed product.

The ServerName property of the SERVERPROPERTY function and @@SERVERNAME return similar information. The ServerName property provides the Windows server and instance name that together make up the unique server instance. @@SERVERNAME provides the currently configured local server name.

The ServerName property and @@SERVERNAME return the same information if the default server name at the time of installation has not been changed. The local server name can be configured by executing the following:

The following example uses the SERVERPROPERTY function in a SELECT statement to return information about the current server. This scenario is useful when there are multiple instances of SQL Server installed on a Windows server, and the client must open another connection to the same instance used by the current connection.