Gail

I'm using the sysindexes to obtain the date that stats were last updated.

I make use of the rows modified and the rowcount

Thanks

So, i'm assuming that the index_id columns is the equivalent?

What do the numbers in that column indicate?

Is 0= Heap

1= Clustered Index

and anything > 1 = Non Clustered...

Without the ('char','nchar','varchar','nvarchar') though

Those arent LOB columns

A Clustered Index whose base table that has any column that is LOB cannot be rebuilt online.

A Non clustered index whose base table has any non key LOB columns participating...

Thanks Perry

Thanks

Try this script

create table #db

(DBNAME varchar(50),

Size float,

remarks varchar(4))

GO

insert into #db

exec sp_databases

select DBNAME, Size/1024 as SizeMB from #db

order by SizeMB desc

drop table #db