We put a few of our own system stored procs in the master database for
certains tasks such as these. They all start sp_XX so we no they're ours.
Here's our rebuild indexes one. Use at your own risk!!!!!

/****** Object: Stored Procedure dbo.sp_XXdbreindex Script Date: 2/19/98
3:50:40 PM ******/
CREATE PROCEDURE sp_XXdbreindex AS
BEGIN
DECLARE @tablename varchar(150)
DECLARE @username varchar(150)
DECLARE @tablename_header varchar(75)
DECLARE tnames_cursor CURSOR FOR SELECT rtrim(b.name),rtrim(a.name)
FROM sysobjects a,sysusers b
WHERE a.type = 'U' and a.uid=b.uid
ORDER BY rtrim(b.name+'.'+a.name)
OPEN tnames_cursor
FETCH NEXT FROM tnames_cursor INTO @username,@tablename
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
SELECT @tablename_header = 'Rebuilding indexes on ' +
@username+'.'+@tablename+'
'+convert(char,getdate())
PRINT @tablename_header
-- PRINT 'DBCC DBREINDEX(''' + @username+'.'+ @tablename + ''', '' '', 0,
SORTED_DATA_REORG)'
EXEC ('DBCC DBREINDEX(''' + @username+'.'+ @tablename + ''', '' '', 0,
SORTED_DATA_REORG)')
END
FETCH NEXT FROM tnames_cursor INTO @username,@tablename
END

SELECT @tablename_header = '************* NO MORE TABLES' + '
*************'
PRINT @tablename_header
PRINT ' '
select @tablename_header = 'Indexes have been rebuilt on all tables.'
PRINT @tablename_header
CLOSE tnames_cursor
DEALLOCATE tnames_cursor
END





GO


----- Original Message -----
From: "Bill King" <[Email Address Removed] "ikke ikke" <[Email Address Removed] <[Email Address Removed] Thursday, August 15, 2002 3:42 PM
Subject: Re: Index...


> Seems like you would just go through one table at a time like this:
>
> dbcc dbreindex ("table1")
> go
>
> dbcc dbreindex ("table2")
> go
>
> dbcc dbreindex ("table3")
> go
>
> etc...
>
> - BILL -
>
>
> ----- Original Message -----
> From: "ikke ikke" <[Email Address Removed] To: <[Email Address Removed] Sent: Thursday, August 15, 2002 10:58 AM
> Subject: Index...
>
>
> >
> > I want to reindex all my indexes in all my tables
> >
> > How i can do that
> >
> > Thank
> >
> >
> > _________________________________________________________________
> > Affichez, modifiez et partagez gratuitement vos photos en ligne:
> > http://photos.msn.com/support/worldwide.aspx
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: mssqldba-[Email Address Removed] > For additional commands, e-mail: mssqldba-[Email Address Removed] >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page