Browse by Tags

• collation
• edition
• license
• server property
• service pack
• tsql
• version

TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?
21 December 07 02:34 AM | SQL Master | 2 Comments   

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered') IsClustered, SERVERPROPERTY('IsFullTextInstalled') Read More...

Filed under: tsql, sql server, collation, edition, version, best practice, engine, license, service pack, server property