Binaryworld - Rebuild All Indexes ... [ SQL Server -> Stored Procedure ]

/*
This stored procedure can be used to rebuild all indexes in the particular
database. You can pass the database name and the fillfactor value into
RebuildAllIndexes stored procedure, as in the example below
(if the database name was not specified, the current database will be used,
if the fillfactor was not specified, the default fillfactor value will be
used):

EXEC RebuildAllIndexes 'pubs', 70
*/

IF OBJECT_ID('RebuildAllIndexes') IS NOT NULL DROP PROC RebuildAllIndexes
GO

CREATE PROCEDURE RebuildAllIndexes (
@dbname sysname = null,
@fillfactor tinyint = null
)
AS
DECLARE @execstr nvarchar(255)
SET NOCOUNT ON
IF @dbname IS NULL SELECT @dbname = DB_NAME()
IF @fillfactor IS NULL
SELECT @execstr = 'EXEC ' + @dbname + '..sp_MSforeachtable @command1="print ''?'' DBCC DBREINDEX (''?'')"'
ELSE
SELECT @execstr = 'EXEC ' + @dbname + '..sp_MSforeachtable @command1="print ''?'' DBCC DBREINDEX (''?'','''',' + str(@fillfactor) + ')"'
EXEC(@execstr)
GO