Indexes Enabled or Disabled?

Hey folks,
SQL Server 2000 SP3/4
How can I determine if an index is enabled or disabled? The information must
be kept somewhere, but I can't seem to find it. Not in sysindexes,
information_schema, sp_helpindex.
Easy to get in SQL 2005 mind you.
--
Thanks,
Scott H.Well, it's been a while, but I don't think you can disable an index on SQL
Server 2000, can you?
"Scott H." <ScottH@.discussions.microsoft.com> wrote in message
news:D12CF217-6C70-4483-B07A-3E00F0A475AA@.microsoft.com...
> Hey folks,
> SQL Server 2000 SP3/4
> How can I determine if an index is enabled or disabled? The information
> must
> be kept somewhere, but I can't seem to find it. Not in sysindexes,
> information_schema, sp_helpindex.
> Easy to get in SQL 2005 mind you.
>
> --
> Thanks,
> Scott H.|||> Well, it's been a while, but I don't think you can disable an index on SQL
> Server 2000, can you?
Nope. That ability was introduced in SQL Server 2005.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uFrZOVhqIHA.552@.TK2MSFTNGP06.phx.gbl...
> Well, it's been a while, but I don't think you can disable an index on SQL
> Server 2000, can you?
>
>
> "Scott H." <ScottH@.discussions.microsoft.com> wrote in message
> news:D12CF217-6C70-4483-B07A-3E00F0A475AA@.microsoft.com...
>> Hey folks,
>> SQL Server 2000 SP3/4
>> How can I determine if an index is enabled or disabled? The information
>> must
>> be kept somewhere, but I can't seem to find it. Not in sysindexes,
>> information_schema, sp_helpindex.
>> Easy to get in SQL 2005 mind you.
>>
>> --
>> Thanks,
>> Scott H.
>|||Ok, that's what I thought. So that makes it easy.
SELECT *, Enabled = 1
FROM sysindexes;
:-)
"Gail Erickson [MS]" <gaile@.online.microsoft.com> wrote in message
news:OOgQMfhqIHA.2292@.TK2MSFTNGP03.phx.gbl...
>> Well, it's been a while, but I don't think you can disable an index on
>> SQL Server 2000, can you?
> Nope. That ability was introduced in SQL Server 2005.
>|||On Tue, 29 Apr 2008 12:21:43 -0400, "Aaron Bertrand [SQL Server MVP]"
<ten.xoc@.dnartreb.noraa> wrote:
>Well, it's been a while, but I don't think you can disable an index on SQL
>Server 2000, can you?
Doesn't look that way from the docs. ALTER INDEX had not been
introduced yet.
Roy Harvey
Beacon Falls, CT|||Good thinking, Aaron!
:-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eZZRWhhqIHA.4476@.TK2MSFTNGP04.phx.gbl...
> Ok, that's what I thought. So that makes it easy.
> SELECT *, Enabled = 1
> FROM sysindexes;
> :-)
>
> "Gail Erickson [MS]" <gaile@.online.microsoft.com> wrote in message
> news:OOgQMfhqIHA.2292@.TK2MSFTNGP03.phx.gbl...
>> Well, it's been a while, but I don't think you can disable an index on SQL Server 2000, can you?
>> Nope. That ability was introduced in SQL Server 2005.
>>
>

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
>>