Check version of sql you are running on server:

Step 1:By using SQL Server Management Studio right clicking on properties of instance name. Here you can see the “Product version” or “Version”.

Step 2:Using T-SQL command.
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’),SERVERPROPERTY (‘edition’)
select @@version

Step 3:Using configuration manager
Open configuration manager expand sql server services right click on instance name. Go to “Advanced Tab” go to to “Stock Keeping Unit Name” and “Version”
First Digit of version:

8.0 for SQL Server 2000
9.0 for SQL Server 2005
10.0 for SQL Server 2008
10.5 for SQL Server 2008 R2
11.0 for SQL Server 2012
12.0 for SQL Server 2014
13.0 for SQL Server 2016

This entry was posted in Query.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s