WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.0%' THEN 'SQL2008' WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '9%' THEN 'SQL2005' WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '8%' THEN 'SQL2000' Here we can see that this file is version Such as "C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\Binn", forįind file sqlservr.exe and right click and select propertiesĪnd a window will open like the one below. Open Windows Explorer and navigate to the folder where SQL Server is installed This is an option if SQL Server is not running
#Sql server 2008 versions install
Method 3 - Find SQL Server version by exe file detailsĪnother option to determine the version of the SQL Server database install is to lookĪt the version of the SQL Server files. (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
#Sql server 2008 versions code
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.
#Sql server 2008 versions how to
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
0 kommentar(er)
