Table of Contents
Video #
Method 1 : Use SQL Query to find SQL Server Version #
a. Launch SQL server management studio and login with your credentials
b. Right click the SQL server and click New Query
c. In the query box type select @@version and click Execute
Method 2 : Use SQLSERVR to find SQL Server Version #
Navigate to C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\
Binn\sqlservr.exe > Right click Properties > Details
Method 3 : Use PowerShell to find SQL Server Version #
Launch the powershell as administrator > Invoke-SqlCmd -query “select @@version” -ServerInstance”localhost”
Note : Replace localhost with your SQL Server Name
Credit By : Webstation
