Indexed Views disabled in Database Engine Tuning Advisor

Hi,
When running the Database Engine Tuning Advisor on an SQL 2005 DataBase, the
two options with "indexed views" were disabled. What causes this SQL Server
isntance not to accept indexed views? I noticed that is't version was
9.0.3042 and not 9.0.3054 as mine: does this has anything to do with it?
thanks a lot and kind regards,
PieterHi Pieter,
Indexed views options are disabled on the GUI if you are using SQL Server
Standard Edition.
Hope this helps,
Ben Nevarez
"Pieter" wrote:
> Hi,
>
> When running the Database Engine Tuning Advisor on an SQL 2005 DataBase, the
> two options with "indexed views" were disabled. What causes this SQL Server
> isntance not to accept indexed views? I noticed that is't version was
> 9.0.3042 and not 9.0.3054 as mine: does this has anything to do with it?
>
> thanks a lot and kind regards,
>
> Pieter
>
>|||Ah, it's indeed a Standard Edition. Thanks! :-)
"Ben Nevarez" <bnevarez@.no.spam.please.sunamerica.com> wrote in message
news:46A1EEC7-F83D-44DC-80D6-43CED822F26C@.microsoft.com...
> Hi Pieter,
> Indexed views options are disabled on the GUI if you are using SQL Server
> Standard Edition.
> Hope this helps,
> Ben Nevarez
>
>
> "Pieter" wrote:
>> Hi,
>>
>> When running the Database Engine Tuning Advisor on an SQL 2005 DataBase,
>> the
>> two options with "indexed views" were disabled. What causes this SQL
>> Server
>> isntance not to accept indexed views? I noticed that is't version was
>> 9.0.3042 and not 9.0.3054 as mine: does this has anything to do with it?
>>
>> thanks a lot and kind regards,
>>
>> Pieter
>>