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”
Thank you again for being a part of this journey with me. Your support is what keeps me inspired and motivated to keep creating and improving. Together, we’ll continue to learn, grow, and have a great time here on Cool IT Help.