Find version of SQLSERVER

Posted on

We often want to know about the version we are using. There are few simple ways to get the version you are on.

1. Simplest way:

SELECT @@version

2. Right click on the SQL Server instance name in SSMS and select Properties




3. Use the SERVERPROPERTY function to get details about the version of SQL Server.

Leave a Reply

Your email address will not be published. Required fields are marked *