DBCC REINDEX

Hi:
On SQL Server 2000 (service pack 3), I am trying to reset the FILLFACTOR to
zero by using DBCC REINDEX option, but it is not allowing it to reset it to
default (i.e. zero). I am able to reset it to 1 - 99 though, just NOT zero.
Any suggestions ''?
thanks in advance,
Kamran.Kamran,
0 equates to 100 which is the default and you can't use the value 0 (must be
between 1-99). I doubt you want the fillfactor to be anywhere near zero.
HTH
Jerry
"Kamran" <Kamran@.discussions.microsoft.com> wrote in message
news:F2D018D3-D3E9-4018-876D-6DA701BF2A17@.microsoft.com...
> Hi:
> On SQL Server 2000 (service pack 3), I am trying to reset the FILLFACTOR
> to
> zero by using DBCC REINDEX option, but it is not allowing it to reset it
> to
> default (i.e. zero). I am able to reset it to 1 - 99 though, just NOT
> zero.
> Any suggestions ''?
> thanks in advance,
> Kamran.|||thanks Jerry..
"Jerry Spivey" wrote:
> Kamran,
> 0 equates to 100 which is the default and you can't use the value 0 (must be
> between 1-99). I doubt you want the fillfactor to be anywhere near zero.
> HTH
> Jerry
> "Kamran" <Kamran@.discussions.microsoft.com> wrote in message
> news:F2D018D3-D3E9-4018-876D-6DA701BF2A17@.microsoft.com...
> > Hi:
> >
> > On SQL Server 2000 (service pack 3), I am trying to reset the FILLFACTOR
> > to
> > zero by using DBCC REINDEX option, but it is not allowing it to reset it
> > to
> > default (i.e. zero). I am able to reset it to 1 - 99 though, just NOT
> > zero.
> >
> > Any suggestions ''?
> >
> > thanks in advance,
> >
> > Kamran.
>
>

DBCC LOGINFO('DBname')

When I run DBCC LOGINFO('DBname') I get 2 and 0 for Status column. How do I
make value 2 as zero before I can truncate the logfile?
ThanksTry to backup the transaction log. then look again.

>--Original Message--
>When I run DBCC LOGINFO('DBname') I get 2 and 0 for
Status column. How do I make value 2 as zero before I can
truncate the logfile?
>Thanks
>.
>