reset fill factor back to 0

[SQLScholar]

How do you set the fill factor of an index back to 0?

I cant seem to find out how online!

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[HarleyQuinn]

Not sure what version of SQL you're running but you can change it with ALTER INDEX.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com

 

[SQLScholar]

unfortunately not (sql 2005 BTW)

It says:

Msg 129, Level 15, State 1, Line 2
Fillfactor 0 is not a valid percentage; fillfactor must be between 1 and 100.


Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[HarleyQuinn]

How about setting it to 100, as mentioned here?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

http://lessthandot.com