SQL Server Training | Tutorials | How to's

SQL Script to find SQL Server Error Log location

-- ******************************************** */
-- Description                                  */
-- ============                                 */
-- Script to find SQL Server Error Log file location
-- This Script will help you to find currently used SQL Server Error Log file.
-- =============================================*/
-- Compatibility  :     2000+                   */
-- ******************************************** */

SELECT SERVERPROPERTY('ErrorLogFileName')

OUTPUT