SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Dec 21, 2007.

  1. Anonymous New Member

    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,...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/12/21/2994.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=2994" width="1" height="1">

Share This Page