Posted by David Portas on 12/31/07 19:47

"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

--
David Portas

[Back to original message]