I have a need to drop and then recreate all indexes in a database. I have tried DBCC DBREINDEX to clean up fragmentation, but now I have been asked to drop and recreate all indexes. Is there a script out there that can do this. I need the script if it exists. I am a newbie and not very good at coding SQL yet.