INDEXDEFRAG FOR SQL SERVER 7.0

From: cedutang (cedutang_at_discussions.microsoft.com)
Date: 01/13/05


Date: Thu, 13 Jan 2005 08:55:02 -0800

Hi, I have SQL Server 7.0 and I want to to defrag all the index but DBCC
INDEXDEFRAG it doesnt work, please anybody Know what command exist for
SQL Server 7.0 ?

I try DBCC DBREINDEX but the fragmentation still.

Thanks.
cedutang.



Relevant Pages

  • [NT] DBCC SHOWTABLEAFFINITY Buffer Overflow in Microsoft SQL Server Explained
    ... Microsoft SQL Server 2000 Enterprise Edition, ... Undocumented command DBCC SHOWTABLEAFFINITYcontains exploitable ... xor eax, eax ...
    (Securiteam)
  • Re: Consequences of Error 644?
    ... If you get the errr while running DBCC - The error is telling you that a row ... but the index entry for some index is missing... ... It says that the problem is a SQL Server ... will happen repeatedly when the customer does the same work which caused the ...
    (microsoft.public.sqlserver.server)
  • Re: sqlservr
    ... > controller's firmware version affecting SQL Server. ... > made a firmware upgrade and aplied patch 8.00.973 on SQL ... > and must activate flag 818. ... DBCC TRACESTATUS ...
    (microsoft.public.sqlserver.server)
  • Re: slow queries for a particular database
    ... DBCC execution completed. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... If there is other database activity going ...
    (comp.databases.ms-sqlserver)
  • Re: INDEXDEFRAG FOR SQL SERVER 7.0
    ... I only implemented DBCC INDEXDEFRAG in SQL Server 2000. ... option is to rebuild the index. ... Can you post before and after results from DBCC SHOWCONTIG? ...
    (microsoft.public.sqlserver.server)