Search results
17 maj 2016 · Method 1: Connect to the instance of SQL Server, and then run the following query: Select @@version. An example of the output of this query is as follows: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009. 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express.
10 wrz 2024 · This article describes the procedures to determine the version and edition of SQL Server Database Engine that is running. Original product version: SQL Server Original KB number: 321185. To determine the version of SQL Server, you can use any of the following methods.
31 paź 2023 · How to tell what version of Microsoft SQL Server you are running? One simple way to do this is to run SELECT @@version; Another option is to right click on the SQL Server instance name in SSMS and select Properties; You can also use the SERVERPROPERTY function to get details about the version of SQL Server; Check out all of the methods in this tip.
7 lip 2021 · In this article we show multiple ways to find the SQL Server version using the SSMS GUI, SQL Server Configuration Manager and using T-SQL code.
8 paź 2019 · We can use the @@VERSION function to find out all version details of the SQL Server instance. The @@VERSION function returns a one-line string output and this output also provides all the necessary information about the SQL Server.
11 gru 2019 · To obtain the SQL Server version numbers, open SQL Server Configuration Manager. Click on SQL Server Services. Right-click on SQL Server instance, SQLServer (SQL2017) in my case, and choose Properties. See the following screenshot:
10 cze 2014 · If you know the version number (e.g. SQL Server 2012 = 110, SQL Server 2014 = 120, etc), you can the Edition for it specifically by running the following at a command prompt: REG QUERY "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\{VersionNumber}\Tools\Setup" /v /e /f Edition