Answer
When GFI Software Products work with Microsoft SQL Server, you need to know what version of Microsoft SQL Server you are running. You can do this by doing the following:Connect to the instance of Microsoft SQL Server, and then run the following query:
Select @@version
An example of the output of this query is as follows:
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
NOTE: the above method was taken from the following article from Microsoft: https://support.microsoft.com/en-us/kb/321185#1. For more alternative ways to find your Microsoft SQL Server version, please refer to the above article.
| SQL Version | Version number |
|---|---|
| SQL Server 2016 | 13.0.1601.5 |
| SQL Server 2014 | 12.0.2000.8 |
| SQL Server 2012 | 11.0.2100.60 |
| SQL Server 2008 R2 | 10.50.1600.1 |
| SQL Server 2008 | 10.0.1600.22 |
| SQL Server 2005 | 9.0.1399.06 |
Priyanka Bhotika
Comments