How to control the disability of SQL Query Analyzer Selection?

Question

Post reply

How to control the disability of SQL Query Analyzer Selection?

SQL ORACLE

One Orange Chip

Points: 27807
More actions
December 14, 2006 at 12:03 pm

#116526

How to control the disability of SQL Query Analyzer Selection when using the Index Tuning Wizard?
Many thanks in advance.
December 18, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

sql_er SSCarpal Tunnel Points: 4135 More actions · Answer 1

Your sentence is a bit confusing.

Could you clarify what exactly you are trying to do with the query analyzer and the index tuning advisor?

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 2

When I tried to use the Index Tuning Wizard, on the page to select Query Analyzer Selection, I found it was disabled. What I would like to know how to enable it?

Any input will be greatly appreciated.

MohammedU SSCoach Points: 19644 More actions · Answer 3

Are you talking about the ITW option in Query Analyser in Query tab?

You should have some query in your QA otherwise it will be greyed out (disabled)...

MohammedU
Microsoft SQL Server MVP

sql_er SSCarpal Tunnel Points: 4135 More actions · Answer 4

Mohammed is right. If you have nothing in the Query Analyzer window, Index Tuning Wizard will be greyed out. As soon as you type a single character in the window, you can go to Query window or press CTRL+I to start up the Index Tuning Wizard.

Tahir-191992 Mr or Mrs. 500 Points: 584 More actions · Answer 5

Just login as

sa

or other superuser.

Best regards,

Tahir275

Kindest Regards,

Tahir

krotha Grasshopper Points: 11 More actions · Answer 6

I have similar issue. but my SQL Query Analyzer is disabled from EM. I can run explicitly but not through the EM. I am running on SQL 2000 with SP4.