

Server 6.5 and SQL Server 7.0 in Enterprise Manager. As you can see with the SQL Server 2000 screenshot itĪlso shows you the service pack that is installed, this is similar for SQL The "Product version" or "Version" gives you a number of the In the general section you will see information such as on the following The first is by using the functionality in SQL Server Management StudioĪnd right clicking on the instance name and selecting Properties. Method 1 - Find Microsoft SQL Server Version with SSMS Check out all of the methods in this tip.

You can also use the SERVERPROPERTY function to get details about the version.One simple way to do this is to run SELECT Another option is to right click on the SQL Server instance name in SSMS.How to tell what version of Microsoft SQL Server you are running? There are a few ways to determine the version of SQL Server that is installed That is running and also what service pack, hotfix, security update or In this tip we look at how to find the version of SQL Server One issue that I am often faced with is determining the version of the This will open the “System Information” window, which includes an overview of your OS X version, your model, your processor (CPU), your memory (RAM) as well as your graphics card and serial number.įor more information on certain components use the corresponding tabs.By: Greg Robidoux | Updated: | Comments (29) | Related: 1 | 2 | 3 | 4 | More > SQL Server Configurations

