Log File Property
New Information - SQL Server 2000 SP3.
This property sets or returns the name of the file used to log Multidimensional Expressions (MDX) queries.
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 Log File property accepts only valid file names with a file extension of .log or .txt. If an invalid file name is provided, the connection attempt fails and an error is raised. If a valid file name is provided with a file extension other than .log or .txt, the file extension .log is appended to the file name.
The format of the log file is as follows:
Process name : Process ID
Command type, one of the following:
MDX - MDX query
SQL - SQL query
DM - Data mining query
Each field in the log file is separated by a space character and terminated by a carriage return/line feed character.