Dear John,

My data base is use for a document management system, and i filter is a plug-in which i use to index my images(something like OCR index for images).

Anyway, I'm...

thanks john , i will remove the check of "remove unused space..."

Do i need to remove "reorganize data and index pages" check?

also what will happened to my i filter?

Is...

@jeff Moden

Thanks Jeff ,

Please tell me how can i determine why this 2 tables takes this amount of unused space?

There is 4 tables with Irrational size of reserved size

2 of them are very huge

1- MiscFileVersion data size = 16 MB yes,Mega Byte:w00t:, Unused = 25GB!!!!! do you...

hi,

a simple solution is to stop sql agent in management , and start it again.

it will rename the database log file and create another file for itself.