regarding the trace... someone asked me to provide that info... i do not know how that would even help them but i ran the one you said and got the...

we are not using TDE... thanks for trying

i ran this ... zero results

SELECT DB_NAME(e.database_id) AS DatabaseName,

e.database_id,

e.encryption_state,

CASE e.encryption_state

WHEN 0 THEN 'No key present - encryption unavailable'

WHEN 1 THEN 'Unencrypted'

WHEN 2 THEN 'Encryption...

Yes I understand this... please note that we do not nor have we ever encrypted any database in our server.

contact Diskeeper for your disk defragmentation. it is a great tool and works when the system is free to keep all the disks on the system defraged... better than window...

thanks grasshopper but it did not do the dbcc command for each table in each data base. i was told that you can not use the USE in a batch....