Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Log File Property

SQL Server 2000

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.

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 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
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.

Show:
© 2015 Microsoft