Alter Index ONLINE = ON/OFF

Last Post 11 Jun 2009 12:20 AM by fosdba. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
fosdba
New Member
New Member

--
10 Jun 2009 12:35 AM
Hi Guys,

I'm trying to pull wheteher an index is set for ONLINE = ON/OFF ? Something to this effect ...

--Get index details
Select tbl.name as TableName, tbl.object_id as ObjectID,
ind.name as IndexName, ind.index_id as IndexID,
sch.name as SchemaName, par.partition_number as PartitionNo
--, ONLINE = ON/OFF ?
from sys.tables tbl
inner join sys.indexes ind on tbl.object_id = ind.object_id
inner join sys.partitions par on ind.object_id = par.object_id and ind.index_id = par.index_id
inner join sys.schemas sch on sch.schema_id = tbl.schema_id
where tbl.type = 'U' and
tbl.name not like 'sys%' and
ind.index_id > 0 --ignore heap

I can not find this setting in the above system tables or in sysindexes, sys.columns, sys.index_columns. Can somebody please explain to me how I must go about to get this ONLINE info ?

Thanks in advance
Marchant
fosdba
New Member
New Member

--
11 Jun 2009 12:20 AM
thanks


Acceptable Use Policy
---