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:
© 2014 Microsoft