Posted by David Greenberg on 01/01/08 09:00

David Portas wrote:
> "David Greenberg" <davidgr@iba.org.il> wrote in message
> news:flaupm$35v$1@news2.netvision.net.il...
>
>>Hi
>>We use Sql 2000.
>>When defining a database maintenance plan one of the options is to
>>optimize the database, reorganize data and index pages, remove unused
>>pages etc.
>>Is there a command to do this manualy (or in a job) and not by usung a DBM
>>plan ?
>
>
> Yes. ALL of the features of Maintenance Plans are T-SQL commands.
>
> http://msdn2.microsoft.com/en-us/library/aa258828(SQL.80).aspx
>

Thanks for the link. Problem is that the "dbcc reindex" works on a
single table , meaning that I have to write a command per table and have
to remember to add a new line for new tables when I add them.
Isn't there a single command that will take care of the whole database
in one go ?

[Back to original message]