How to determine the SQL Server Version for an Environment

Description of Issue

Need to know the SQL Server version for an environment

Context
  • SQL Server Management Studio (SSMS)
  • Enterprise ERP (Munis)
  • Database
  • System Administration
Resolution
  1. Access environment in question through SSMS, How Do I Connect to a Database Using SSMS
  2. Right-click on the database and select New Query
  3. Enter the following: select @@version
  4. Click Execute
  5. Version will show in Results window
Additional Information