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 added DBCC INDEXDEFRAG in SQL Server 2000 so your only opion in ... Can you post before and after output from DBCC SHOWCONTIG as I'm curious as ... the fragmentation calculations in DBCC SHOWCONTIG ... before SQL Server 2000 did not take account of multiple files so it will not ...
    (microsoft.public.sqlserver.server)