Lastly, we will type the SQL query select and press enter. We can also type remote server hostname or IP address and specify the instance name like poftut/mydatabase. We will provide the hostname of the server with the -s option like below. We will connect to the local database server command line with the sqlcmd command by providing the hostname or IP address of the server which is localhost in this case. We will see a clean MS-DOS command prompt. Alternatively WIN+R and cmd can be used too. From the Start Menu type cmd and press enter. In this example, we will use the MS-DOS but PowerShell is ok too. First, we will launch the command-line interface and the SQL command line. We can also use the command line like Ms-DOS or PowerShell in order to list currently installed MS SQL Server Database version.
MS SQL Server Version Information From Error Log How To Find MS SQL Server Version From Command Line Also, information like build architecture, edition, current host operating system are provided. We can see that the MS SQL Server 2019is installed with the version number.
We will open this path with the Windows Explorer and open the log file with a text editor like Notepad++. We can see from the result of the query that the ERRORLOG file is located at the C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log path. SELECT SERVERPROPERTY('ErrorLogFileName') AS 'Error log file location' MS SQL Server Error Log Path Query First, we will list the log path for the current MS SQL Server by using the following query. The MS SQL Server version information is logged into the ERRORLOG file at the start of the file. We can also find the MS SQL Server version from the log files. How To Find MS SQL Ser Version From sqlservr.exe How To Find MS SQL Server Version From Error Logs This path can be different according to the operating system architecture like 32 and 64 bit. This executable can also provide information about the MS SQL DAtabase Server version. The SQL Server Daemon executable file is named as sqlservr.exe and stored in the C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn path. How To Find MS SQL Ser Version From sqlservr.exe
`Operation System Version` is Windows 10 Professional 64 bit with build number 17134.SQL Server edition is `Enterprise Evaluation Edition`.