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.
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.