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
Query Log File and Usage Based Optimization
Yuying C. Mesaros
Edward
Thanks.
Dan3johns
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.