Friday, June 12, 2015

How to determine the version and edition of SQL Server and its components

To determine the version of the client tools that are installed on your system, start Management Studio, and then clickAbout on the Help menu. (The screen shot for this step is listed below).


How to determine which version and edition of SQL Server Database Engine is running

Connect to the instance of SQL Server, and then run the following query:

Select @@version