re-index

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.
========================================
==============
--[vbcol=seagreen]|||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.
> ========================================
==============
>
> --
>|||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.
========================================
==============
--[vbcol=seagreen]|||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.
> ========================================
==============
>
> --
>|||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/pr...in/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.
========================================
==============
--[vbcol=seagreen]
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>[vbcol=seagreen]
so[vbcol=seagreen]
rights.[vbcol=seagreen]|||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/pr...in/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.
========================================
==============
--[vbcol=seagreen]
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>[vbcol=seagreen]
so[vbcol=seagreen]
rights.[vbcol=seagreen]