HOW TO know the SQL Server version installed

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:

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  (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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.