Log File Property

Analysis Services Programming

Analysis Services Programming

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.