SET NOCOUNT ON

DECLARE @tablename VARCHAR (128)
DECLARE @execstr   VARCHAR (255)

DECLARE indexes CURSOR FOR
SELECT 
	sysobjects.name
FROM
	sysobjects 
WHERE
	sysobjects.name like 'tab_%'

-- Open the cursor
OPEN indexes

-- loop through the indexes
FETCH NEXT
   FROM indexes
   INTO @tablename

WHILE @@FETCH_STATUS = 0
BEGIN
   PRINT 'Executing DBCC DBREINDEX (''' + RTRIM(@tablename) + ''')' + char(10)
   SELECT @execstr = 'DBCC DBREINDEX (''' + RTRIM(@tablename) + ''')'
   EXEC (@execstr)

   FETCH NEXT
      FROM indexes
      INTO @tablename
END

-- Close and deallocate the cursor
CLOSE indexes
DEALLOCATE indexes