Finding the SQL Server version with query We can use the @@VERSION function to find out all version details of the SQL Server instance. The @@VERSION function returns a one-line string output and this output also provides all the necessary information about the SQL Server.
Using the Windows Command Prompt On the workstation that SQL is installed, choose Start > Run, and enter cmd in the Open field, and then press Enter to launch a command prompt window. Type select @@version and press Enter.
What's the easiest way to check for the SQL Server Edition and Version using powershell?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With