I'm deploying a SQL Server database to Azure. I've tried to export to a
.bacpac, but receive an error:
fill factor set and is not supported when as part of a data package
Using the script in this link I can locate where the fill factors indexes are. I face 2 issues:
The index property page will not let me set the fill factor to 0. I have read that 100 is the same as 0. This does work.
I have too many indexes to do manually. Is there a script I can use that will reset this value to 0?