sql server, service pack, edition, best practice - SQLServer-QA.net

Browse by Tags

TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running? Published 21 December 7 3:34 AM | SSQA.net: Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered'...

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