servername and SERVERPROPERTY('ServerName') are the same, only case is different · Issue #651 · olahallengren/sql-server-maintenance-solution · GitHub
![Interview Question of the Week #028 - T-SQL Script to Detect SQL Server Version and Property - SQL Authority with Pinal Dave Interview Question of the Week #028 - T-SQL Script to Detect SQL Server Version and Property - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/a/sqlversion.jpg)
Interview Question of the Week #028 - T-SQL Script to Detect SQL Server Version and Property - SQL Authority with Pinal Dave
![Dinesh's Blog :::: Being Compiled ::::: SQL Server SERVERPROPERTY - SQL Server 2016 TSQL Enhancements Dinesh's Blog :::: Being Compiled ::::: SQL Server SERVERPROPERTY - SQL Server 2016 TSQL Enhancements](https://4.bp.blogspot.com/-9dUnH5VxdV4/V0Cklf7xnKI/AAAAAAAADqE/pxkiEfyAam8cBtRK1lkLWgeTlhAk7Zn7QCLcB/s1600/ServerProperty%2B01.png)
Dinesh's Blog :::: Being Compiled ::::: SQL Server SERVERPROPERTY - SQL Server 2016 TSQL Enhancements
![How to find SQL Server Version and Which Service Pack is Installed on SQL Server | PCTechnow – More Computer, Desktop, and Server Issues Resolved How to find SQL Server Version and Which Service Pack is Installed on SQL Server | PCTechnow – More Computer, Desktop, and Server Issues Resolved](https://pctechnow.files.wordpress.com/2014/05/how-to-find-sql-server-version-and-which-service-pack-is-installed-on-sql-server.png)
How to find SQL Server Version and Which Service Pack is Installed on SQL Server | PCTechnow – More Computer, Desktop, and Server Issues Resolved
![The Truth Behind FilestreamEffectiveLevel and FilestreamConfiguredLevel SERVERPROPERTY values | Sven Aelterman The Truth Behind FilestreamEffectiveLevel and FilestreamConfiguredLevel SERVERPROPERTY values | Sven Aelterman](https://svenaelterman.files.wordpress.com/2012/01/windows-7-ee-test-v4-2012-01-02-21-33-50.png)