How to access SQL Server error log in Microsoft SQL Server Management Studio | Tutorial or Beginners
Автор: Cool IT Help
Загружено: 2023-07-11
Просмотров: 666
In this tutorial, we will learn how to access SQL server logs in SQL Server Management Studio. Also, we will learn the following things.
1) Access your SQL Server error log
2) Query the error log in SSMS (sp_readerrorlog 0,1,' Server process ID')
3) Find the error log location if you're connected to SQL Server
SELECT SERVERPROPERTY('ErrorLogFileName') AS 'Error log file location'
4) Find the error log location if you can't connect to SQL Server
Open SQL Server Configuration Manager
select SQL server --: Expand services --: properties then
Select the 'Startup Parameters' tab.
-e"path"
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: