---
title: "How to check SQL Server version"  
description: "How to check SQL Server version"  
author: "Tarun Kumar"  
published: 2016-11-07  
updated: 2016-11-07  
canonical: https://www.mindstick.com/forum/34202/how-to-check-sql-server-version  
category: "database"  
tags: ["sql server", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# How to check SQL Server version

Hello Guys,\
I want to know which [version](https://www.mindstick.com/articles/12845/things-to-remember-while-migrating-odoo-to-a-better-version) of [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) is [installed on my machine](https://www.mindstick.com/forum/158974/how-to-know-if-dot-net-core-is-installed-on-my-machine)?Please help.\
Thanks\

## Replies

### Reply by Tarun Kumar

Thanks for quick reply..got it..thank you

### Reply by John Smith

check this post on stackoverflow http://stackoverflow.com/questions/20351674/how-to-check-[sql](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database)-[server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over)-version

### Reply by Uttam Misra

Following query will return you version name and number:\
select @@version\


---

Original Source: https://www.mindstick.com/forum/34202/how-to-check-sql-server-version

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.