|
|
Posted by Knowledgy on 01/09/08 20:01
You can use the undocumented system stored proc called
Sp_msforeachtable
The parameter is the command you want to run and the proc will execute it
against every table within the database
--
Sincerely,
John K
Knowledgy Consulting, LLC
www.knowledgy.org
Atlanta's Business Intelligence and Knowledge Management Experts
"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]
|