SQL Server SERVERPROPERTY() Use Cases
https://www.mssqltips.com:443/sqlservertip/6837/sql-server-serverproperty-use-cases/
WEBApr 30, 2021 · We can get SQL Server instance specific properties like default data and log directories, which version of .NET CLR is installed, collation type, authentication mode or whether your instance is SQL Server express for example, using this one system function SERVERPROPERTY().
DA: 36 PA: 49 MOZ Rank: 73