Re: Database maintenance using DBCC DBREINDEX

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Julie (anonymous_at_discussions.microsoft.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 06:50:28 -0700

As far as I know there is no Microsoft official version
that does the same, sorry.

However you can get all the user tables from your database
by doing

select Name from sysobjects where xtype = 'U'

J

>-----Original Message-----
>Thanks,
>
>Do you know if there is a similar stored procedure that
is supported?
>
>Jo.
>
>"Julie" <anonymous@discussions.microsoft.com> schreef in
bericht
>news:201f01c42789$52e4ddb0$a601280a@phx.gbl...
>> Hi Jo,
>>
>> The command sp_msForEachTable is no longer supported my
>> Microsoft. This means on the next release of SQL Server
it
>> may or may not be part of it.
>>
>> If its not supported then there are no BOL's for it.
>>
>> J
>>
>>
>> >-----Original Message-----
>> >Hi,
>> >
>> >Currently, I use sp_msForEachTable to reindex every
table
>> in one of my
>> >databases. However I did not find any information
>> regarding this stored
>> >procedure in BOL. Is it safe to use, or why isn't it
>> documented?
>> >
>> >EXEC sp_msForEachTable @COMMAND1='DBCC DBREINDEX ("?")'
>> >
>> >Yours sincerely,
>> >
>> >Jo Segers.
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Backup still not working
    ... So you may try to rebuild the RSM database if the ... > rename the existing files in this folder to a .old file extension, ... > this time unchecks "First Storage Group" under Microsoft Exchange Server. ... > 1) Open SQL Server Enterprise Manager. ...
    (microsoft.public.windows.server.sbs)
  • Re: cant move sharepoint by the instructions. AGAIN
    ... Monitoring database to another location. ... If you installed the SQL Server or the SQL Server Management Tools, ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: MS Access DAO -> ADO.NET Migration
    ... Microsoft chose to change the name from SQL Server Everywhere ... It's a fully relational database that supports a subset of the ... DAO has methods and properties that are Access ...
    (microsoft.public.dotnet.framework.adonet)