Question: How Old Version of SQL Server Running on Server?
Answer: During the recent Comprehensive Database Performance Health Check, I was this question. I always thought many know the answer to this question but it seems it is not true. To my surprise, I found that not many know the answer to this question.
To know the current version of SQL Server, you just have to run following command.
SELECT @@VERSION
When you run above command, it will display the following results.
In the result above, you can clearly see version information with the date when was the patch created.
Whenever I go for a consulting engagement, I always run the command first as it helps me to understand what is the code base they are running and how it will behave. It is very important for any consultant to get himself to familiarize with the codebase and its behavior.
- SQL SERVER – Identify Version of SQL Server from Backup File
We can figure out details about the server, login and database version by just checking the header details of the backup files. - SQL Server – Getting Started with Project Versions in the SSIS Catalog – Notes from the Field #106
- SQL SERVER – Get Server Version and Additional Info
Reference: Pinal Dave (http://blog.SQLAuthority.com)