How to get the current DBs log file folder

• Mark Firth

  Newbie

  Points: 9

  More actions

  September 14, 2004 at 8:33 pm

  #63429

  Using SQL 2k

  I want to write to a text file in the current DBs log file folder. This is to audit the processing of a scheduled DTS package.

  Is there any method of finding out the correct folder name.

• Dølle Døck

  Mr or Mrs. 500

  Points: 577

  More actions

  September 15, 2004 at 2:00 am

  #523109

  You can find it in masters table sysaltfiles.

  Use master

  SELECT * FROM dbo.sysaltfiles

  ---

  Regards,

  Anders Dæmroen
  epsilon.no