Which sql version am i running

This will return the SQL version that is running on your server. If you have multiple instances repeat the process for each instance. The servername mentioned above will be the name of the machine SQL is installed on. Step 3 - Locate the entries beginning with SQL.

Support center. Connect with your community. Featured Quickfinder bundles The more you buy, the more you save with our quantity discount pricing.

Shop all bundles. If the System Information portlet is not currently available on any tabs in the dashboard, click the Add View link in the upper-right corner of the Home Dashboard. Mark the System Information checkbox and click OK to view the system information in the portlet. This icon appears alongside links to resources that are not developed or maintained by Thomson Reuters. We provide access to these resources for your convenience, but we are not responsible for their accuracy.

Was this article helpful? Yes No Great! The following query returns the location of the error log file:. The entry of the error log file provides all details about the SQL Server build. In this article, we mentioned how to find out the SQL Server version with the different methods and also learned how to convert it to more meaningful information.

After reading this article, you should be able to distinguish which SQL Server product version number corresponds exactly to which specific definition and other detailed information. Author Recent Posts.

Esat Erkec. His current interests are in database administration and Business Intelligence. The first is by using the functionality in SQL Server Management Studio and right clicking on the instance name and selecting Properties.

In the general section you will see information such as on the following screenshots. The "Product version" or "Version" gives you a number of the version that is installed. Another option is to run the T-SQL command to give you this information. The one thing that you do not get when you do this is the Service Pack name like you do in Enterprise Manager. When this is T-SQL code or a stored procedure with this command is run it will give you information such as the build number and Windows Server operating system:.

Microsoft SQL Server - 8. Microsoft SQL Server - 9. Microsoft SQL Server - This is an option if SQL Server is not running and you need to find the version. Find file sqlservr. Here we can see that this file is version So now that you have this number such as 9. The first digits refer to the version of SQL Server such as:.

Here are a couple of links to other articles that give you the details of what is installed for SQL Server 6. Hi Sergei, sure you could use the RTM version, but there have been several cumulative updates since the RTM release and it would make sense to apply the updates.