cashao.blogg.se

(Build 7601: Service Pack 1) (Hypervisor) SQL Server 2016 (Build 7601: Service Pack 1) (Hypervisor) SQL Server 2014ĭeveloper Edition (64-bit) on Windows NT 6.1 NT 6.0 (Build 6002: Service Pack 2) SQL Server 2012 On Windows NT 6.1 (Build 7601: Service Pack 1) SQL Server 2008 R2 06 (Intel X86)Ĭopyright (c) 1988-2005 Microsoft Corporationĥ.1 (Build 2600: Service Pack 2) SQL Server 2008 SELECT this is T-SQL code or a stored procedure with this command is run it will give you information such as theīuild number and Windows Server operating system: SQL Server 2000 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