>>Here's shorter one

USE Northwind
>>EXEC sp_MSforeachtable @command1="DBCC DBREINDEX ('?')"
>>

>>
>
>Thanks Sergey, for the Undocumented sp.
>
>The usual defect of the big software house,
>to the face of the proclaims of security of the software.

I forgot to include the link http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocSP.htm.