|
|
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
Navigation:
[Reply to this message]
|