by dotnetpete
29. April 2009 13:31
Found a very cool undocumented stored procedure in SQL today.
For example if I want to rebuild all indexes for all tables I could do
sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"
Very handy!
66161bf7-28e3-4447-80bb-ec7eb6abbc7b|0|.0
Tags:
SQL2008