I have some indexes that I was playing with on my dev server. I set the fill factor of these indexes using the following command:
alter index all on dbo.Table rebuild with (fillfactor=80)
That sets and rebuilds all of the index on dbo.Table. Now what I want is to set the fillfactor back to the default of the server. IE, at the server level all indexes are set to have a fillfactor of 95. I want the indexes to use the server default again, not just have the fill factor set to 95.
The reason I want to do this is so that, if I script this index and move it to a new server, it will use the default fill factor of that server rather than the specified 95.