Analysis Services Programming
Log File Property
This property sets or returns the name of the file used to log
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.