Query Log File and Usage Based Optimization

Hi

I have successfully created a QueryLog.trc file but when I enter the Usage Based Optimization wizard it complains that I have not configured the server parameter QueryLog\ QueryLogConnectionString. Does the wizard support the use of a file rather than a table?

Im using the RTM version.

Cheers

The Usage Based Optimization wizard expects to find a SQL Server table.

Here is whitepaper on how to setup a Query Log: http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/config_ssas_querylog.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward

Thanks.