sp_readerrorlog
LogDate ProcessInfo Text
2018-07-23 12:13:16.530 Server Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)
Aug 22 2017 17:04:49
Copyright (C) 2017 Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 16299: )
2018-07-23 12:13:16.530 Server UTC adjustment: 9:00
2018-07-23 12:13:16.530 Server (c) Microsoft Corporation.
2018-07-23 12:13:16.530 Server All rights reserved.
2018-07-23 12:13:16.530 Server Server process ID is 5056.
2018-07-23 12:13:16.530 Server System Manufacturer: 'HP', System Model: 'HP 280 G3 MT'.
2018-07-23 12:13:16.530 Server Authentication mode is WINDOWS-ONLY.
2018-07-23 12:13:16.530 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2018-07-23 12:13:16.540 Server The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.
2018-07-23 12:13:16.540 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQL
2018-07-23 12:13:16.540 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2018-07-23 12:13:18.330 Server SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2018-07-23 12:13:18.330 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
...
