T-SQL to Check SQL ErrorLog file location Leave a reply At the start up of SQL Server records the startup parameter details into the error log. You can query the error log to check the error log file physical location. USE master GO xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc' GO 18.520469 73.856621 Share this: Share on Facebook (Opens in new window) Facebook Share on Tumblr (Opens in new window) Tumblr Share on LinkedIn (Opens in new window) LinkedIn Share on Reddit (Opens in new window) Reddit Print (Opens in new window) Print Share on X (Opens in new window) X Email a link to a friend (Opens in new window) Email Share on Pinterest (Opens in new window) Pinterest Like Loading... Related