Getting MS SQL Server Info
Published on: 16 January 2008 By: Ahsan Khan
SQL SERVER SERVERPROPERTY
Syntax
SERVERPROPERTY(propertyname)
Arguments
propertyname
EXAMPLE
Getting Server Information using ServerProperty.
SELECT @@VERSION AS [Server Information]
, SERVERPROPERTY('ServerName') AS [ServerName]
, SERVERPROPERTY('MachineName') AS [MachineName]
, SERVERPROPERTY('InstanceName') AS [InstanceName]
, SERVERPROPERTY('productversion') AS [ProductVersion]
, SERVERPROPERTY('ProductLevel') AS [ProductLevel]
, SERVERPROPERTY('Edition') AS [Edition]
, SERVERPROPERTY('Collation') AS [Collation]
, SERVERPROPERTY('IsClustered') AS [IsClustered]
, SERVERPROPERTY('IsFullTextInstalled') AS [IsFullTextInstalled]
, SERVERPROPERTY('IsIntegratedSecurityOnly') AS
[IsIntegratedSecurityOnly]
, SERVERPROPERTY('LicenseType') AS [LicenseType]
, SERVERPROPERTY('NumLicenses') AS [NumLicenses]
Example Results
Server Information
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)
Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 6.0 (Build 6000: )
ServerName
Workstation01\SQLSERVER2005
MachineName
Workstation01
InstanceName
SQLSERVER2005
ProductVersion
9.00.3054.00
ProductLevel
SP2
Edition
Developer Edition
Collation
Latin1_General_CI_AS
IsClustered
0
IsFullTextInstalled
1
IsIntegratedSecurityOnly
1
LicenseType
Disabled
NumLicenses
NULL
View All Articles (Articles Archive)