|
Posted by Jack Vamvas on 01/11/08 16:31
Check SQL Books Online and search DBCC SHOWCONTIG - there is a script in
there which is useful and deals
with all the tables
--
Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com
"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 ?
Navigation:
[Reply to this message]
|