steve,

ORDER BY len([data]),[data]

why is this not recommended? it's the simplest solution.

Excellent! Many thanks!

cool thanks

better yet though...

select sys.objects.name as 'table',

sys.indexes.name as 'index',

is_disabled = case is_disabled

when '1' then 'disabled'

when '0' then 'enabled'

end

from sys.objects join sys.indexes

on sys.objects.object_id = sys.indexes.object_id

where sys.objects.name =...

xp_cmdshell 'net stop SQLSERVERAGENT'

thats it.

though you may need to enable the xp_cmdshell.

interesting...

i'll keep that in mind.

thanks!

cool thanks.

i found it.

if i just look under each RS Server and find

the ReportServer database i can run a query against

the Catalog table, and just compare them to each

servers ReportServer.dbo.Catalog table.

nevermind... i found it.

most of the information i was looking for CAN

be queried from the ReportServer database.

the information is located in the Catalog table.

john

many thanks.

i'm making those changes now. i'll just change the column

name to something like [mb_size]

thanks for all the quick replies!

SQLBill

I was just mentioned the kb, mb, gb as a general thought. i'm

not really collecting all that information. just a...

seems like there would be a free little utility some where

which would allow you to do just that.

ahh well... what can you do?

thanks for all the good feed back people!

i'm looking over teh msinfo stuff now, and i'll

see how i can hit all the servers in my environment

at once.

unfortunately i'm not that well versed in this and i don't

know how to use OPENROWSET in a loop, dynamic stringg with xp_cmdshell.

forgive me if i'm asking too much, but is...

oops...

ok then; thanks alot MVJ!

grasshopper,

your stuff worked G R E A T!!

thanks for the post!