How Old Version of SQL Server Running on Server? – Interview Question of the Week #183

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.

How Old Version of SQL Server Running on Server? - Interview Question of the Week #183 version

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.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQL Patch, SQL Scripts, SQL Server
Previous Post
How to Convert Hex Windows Error Codes to the Meaningful Error Message – 0x80040002 and 0x80040005 and others? – Interview Question of the Week #182
Next Post
How to Check Status of Instant File Initialization? – Interview Question of the Week #184

Related Posts

Leave a Reply