If I spell out the destination path without clicking on the ... button it will be fine. But, this is not I expect, I thought it can search for the...

Well, I do agree with all of your opinions. Simply and blindly follow DTA's suggestion could be negative move sometime.

But at least, it is an useful tool for some...

Hi Yaron,

I was trying to use DTA to check and get some suggestion of which table to be indexed.

I found it is usefull for SQL2000 and I have...

Any pro out there has a solution for me? TIA

The SQL server is installed at my note book and virtually no load because I am the only one using it at all time for development purpose.

Also, I login as...

Good idea!

Thanks again.

Hi Ninja, thanks for your reply, I actually want to querry the same table with diffrent expression.

Hope you can follow sample code below,

...

DECLARE @tbl_1 char(500), @tbl_2 char(500), @tbl_3...