In Microsoft SQL Server, you can enable and disable the autogrowth function.
1. Open the SQL Server Management Studio. Right click on the database instance. Choose Properties. Look for Files page and click on the Autogrowth tab. You will see the Change Autogrowth for XXXX. The autogrowth function need to be set on independently on each data files. So, to enable or disable, you can just tick or untick the Enable Autogrowth.
Note
File Growth
– In Percent
– In Megabytes
Maximum
– Restricted File Growth (MB)
– Unrestricted File Growth
