re-index

How do you re-index in SQL 2000? Thanks.Take a look at dbcc dbreindex on Books Online.
Ben Nevarez, MCDBA, OCP
Database Administrator
"00KobeBrian" wrote:
> How do you re-index in SQL 2000? Thanks.
>
>|||Hi,
Check following two articles:
http://msdn2.microsoft.com/en-us/library/ms181671.aspx
http://msdn2.microsoft.com/en-us/library/ms188388.aspx
They apply to SQL 2000 as well.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Thread-Topic: re-index
>>thread-index: AcacAMlXlL8ktvHYQViANEhvVtN9nA==>>X-WBNR-Posting-Host: 66.174.79.241
>>From: =?Utf-8?B?QmVuIE5ldmFyZXo=?= <bnevarez@.sjm.com>
>>References: <OF8reV$mGHA.4964@.TK2MSFTNGP04.phx.gbl>
>>Subject: RE: re-index
>>Date: Thu, 29 Jun 2006 21:51:01 -0700
>>Lines: 13
>>Message-ID: <DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.server
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436825
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>
>>Take a look at dbcc dbreindex on Books Online.
>>Ben Nevarez, MCDBA, OCP
>>Database Administrator
>>
>>"00KobeBrian" wrote:
>> How do you re-index in SQL 2000? Thanks.
>>
>>|||Hi Vincent,
Looks like alter index does not apply to SQL Server 2000.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Vincent Xu [MSFT]" wrote:
> Hi,
> Check following two articles:
> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
> They apply to SQL 2000 as well.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ======================================================> Get Secure! - www.microsoft.com/security
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties,and confers no rights.
> ======================================================>
> --
> >>Thread-Topic: re-index
> >>thread-index: AcacAMlXlL8ktvHYQViANEhvVtN9nA==> >>X-WBNR-Posting-Host: 66.174.79.241
> >>From: =?Utf-8?B?QmVuIE5ldmFyZXo=?= <bnevarez@.sjm.com>
> >>References: <OF8reV$mGHA.4964@.TK2MSFTNGP04.phx.gbl>
> >>Subject: RE: re-index
> >>Date: Thu, 29 Jun 2006 21:51:01 -0700
> >>Lines: 13
> >>Message-ID: <DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
> >>MIME-Version: 1.0
> >>Content-Type: text/plain;
> >> charset="Utf-8"
> >>Content-Transfer-Encoding: 7bit
> >>X-Newsreader: Microsoft CDO for Windows 2000
> >>Content-Class: urn:content-classes:message
> >>Importance: normal
> >>Priority: normal
> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> >>Newsgroups: microsoft.public.sqlserver.server
> >>Path: TK2MSFTNGXA01.phx.gbl
> >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436825
> >>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> >>X-Tomcat-NG: microsoft.public.sqlserver.server
> >>
> >>
> >>Take a look at dbcc dbreindex on Books Online.
> >>
> >>Ben Nevarez, MCDBA, OCP
> >>Database Administrator
> >>
> >>
> >>"00KobeBrian" wrote:
> >>
> >> How do you re-index in SQL 2000? Thanks.
> >>
> >>
> >>
> >>
>|||Hi All,
Sorry, my mistake.I assume this as a matter of course
We have to use DBCC
Check following article:
<http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.msp
x>
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Thread-Topic: re-index
>>thread-index: AcacDD33LO1Sb0jRQ3OKhL7Qt+d/RQ==>>X-WBNR-Posting-Host: 150.202.8.1
>>From: =?Utf-8?B?QmVuIE5ldmFyZXo=?= <bnevarez@.sjm.com>
>>References: <OF8reV$mGHA.4964@.TK2MSFTNGP04.phx.gbl>
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>
>>Subject: RE: re-index
>>Date: Thu, 29 Jun 2006 23:13:01 -0700
>>Lines: 82
>>Message-ID: <97CCD26D-249B-46EB-8657-9A6DC5339867@.microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.server
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436830
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>
>>Hi Vincent,
>>Looks like alter index does not apply to SQL Server 2000.
>>Ben Nevarez, MCDBA, OCP
>>Database Administrator
>>
>>"Vincent Xu [MSFT]" wrote:
>> Hi,
>> Check following two articles:
>> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
>> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
>> They apply to SQL 2000 as well.
>> Thanks.
>>
>> Best regards,
>> Vincent Xu
>> Microsoft Online Partner Support
>> ======================================================>> Get Secure! - www.microsoft.com/security
>> ======================================================>> When responding to posts, please "Reply to Group" via your newsreader
so
>> that others
>> may learn and benefit from this issue.
>> ======================================================>> This posting is provided "AS IS" with no warranties,and confers no
rights.
>> ======================================================>>
>> --
>> >>Thread-Topic: re-index
>> >>thread-index: AcacAMlXlL8ktvHYQViANEhvVtN9nA==>> >>X-WBNR-Posting-Host: 66.174.79.241
>> >>From: =?Utf-8?B?QmVuIE5ldmFyZXo=?= <bnevarez@.sjm.com>
>> >>References: <OF8reV$mGHA.4964@.TK2MSFTNGP04.phx.gbl>
>> >>Subject: RE: re-index
>> >>Date: Thu, 29 Jun 2006 21:51:01 -0700
>> >>Lines: 13
>> >>Message-ID: <DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
>> >>MIME-Version: 1.0
>> >>Content-Type: text/plain;
>> >> charset="Utf-8"
>> >>Content-Transfer-Encoding: 7bit
>> >>X-Newsreader: Microsoft CDO for Windows 2000
>> >>Content-Class: urn:content-classes:message
>> >>Importance: normal
>> >>Priority: normal
>> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>> >>Newsgroups: microsoft.public.sqlserver.server
>> >>Path: TK2MSFTNGXA01.phx.gbl
>> >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436825
>> >>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>> >>X-Tomcat-NG: microsoft.public.sqlserver.server
>> >>
>> >>
>> >>Take a look at dbcc dbreindex on Books Online.
>> >>
>> >>Ben Nevarez, MCDBA, OCP
>> >>Database Administrator
>> >>
>> >>
>> >>"00KobeBrian" wrote:
>> >>
>> >> How do you re-index in SQL 2000? Thanks.
>> >>
>> >>
>> >>
>> >>
>>