>>>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.
Never problem Sergey.
I like not to use not official document behaviours,
but at dev time some time must yield