Displaying the SQL Server Version

When problems arise in your system, it is always important to check whether the system is up-to-date and all available service packs have been imported.

Procedure

To find out the version of your SQL Server, look at the first line of the current SQL Server Error Log.

To view logs proceed as follows:

1. In the SQL Server Management Studio, expand the server, Management and SQL Server Logs.

   A list of all the available logs is displayed.

2. Double-click the current log.

   The content of the log is displayed in the Log File Viewer.

3. Look at the last line of the log. It shows the exact version of the server.

   For example:

   Microsoft SQL Server 2008 - 10.00.xxxx

   The last 4 digits (xxxx) indicate the build number, which designates a certain service pack level.

You can also check the version of your SQL Server as follows

1. Connect to the SQL server in the SQL Server Management Studio.
2. Right-click on the server and select Properties.

   You can see the SQL Server version in the Version column.