Log File Property

This property sets or returns the name of the file used to log Multidimensional Expressions (MDX) queries.

Property Name

Log File

Property ID

DBPROP_MSMD_LOG_FILE

Remarks

Use this property to specify a file name for logging MDX queries. The specified file is opened for exclusive use by the connection; subsequent attempts by other connections to open the same file will fail. The format of the log file is as follows:

Process name : Process ID
Date
Time
Command type, one of the following:
  MDX - MDX query
  SQL - SQL query
  DM - Data mining query
Query text

Each field in the log file is separated by a space character and terminated by a carriage return/line feed character.