Welcome to

SqlServer-QA.net

Sign in | Join | Help

TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?

Use the following TSQL 

SELECT SERVERPROPERTY('Collation')                          Collation,
              SERVERPROPERTY('Edition')                            Edition,
              SERVERPROPERTY('Engine Edition')                 EngineEdition,
              SERVERPROPERTY('InstanceName')                 InstanceName,
              SERVERPROPERTY('IsClustered')                      IsClustered,
              SERVERPROPERTY('IsFullTextInstalled')            IsFullTextInstalled,
              SERVERPROPERTY('IsIntegratedSecurityOnly')   IsIntegratedSecurityOnly,
              SERVERPROPERTY('IsSingleUser')                    IsSingleUser,
              SERVERPROPERTY('IsSyncWithBackup')           IsSyncWithBackup,
              SERVERPROPERTY('LicenseType')                    LicenseType,
              SERVERPROPERTY('MachineName')                 MachineName,
              SERVERPROPERTY('NumLicenses')                  NumLicenses,
              SERVERPROPERTY('ProcessID')                       ProcessID,
              SERVERPROPERTY('ProductVersion')                ProductVersion,
              SERVERPROPERTY('ProductLevel')                   ProductLevel,

              SERVERPROPERTY('ServerName')                    ServerName

To answer the second part of the question, best to refer to http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html link.

Published Friday, December 21, 2007 2:34 AM by SQL Master

Comments

# TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition'

Friday, December 21, 2007 2:37 AM by SSQA.net - SqlServer-QA.net

# TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition'

Friday, December 21, 2007 2:57 AM by Other SQL Server Blogs around the Web
Anonymous comments are disabled