Set Auto growth for all the databases in SQL Server

Introduction

Below script will give the command to execute to change the database auto-growth. If you need to execute for only a single database, then please copy the relevant rows and execute.

SQL Script for database Auto Growth

SQL Script for database Auto Growth

Using GUI

The same result can be obtain by using GUI SSMS also. Set Auto growth for SQL database using GUI

Set Auto growth for SQL database using GUI


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *