SQL Script to Find SQL Server Error Log location

Leave a comment (0) Go to comments

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


SQL Script to Find SQL Server Error Log location sql server error log location script to find sql server error log

EOF - SQL Script to Find SQL Server Error Log location, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.