There are different methods how to know the SQL Server version installed.
My preferred, for me the easiest to remember, is run the following query:
[sourcecode lang=”sql”]Select @@version[/sourcecode]
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
(Build 7600: )
For further info, please, use the reference link.
Reference: How to determine the version and edition of SQL Server and its components
Did my HOW TO help you? Leave a reply.