You can follow below steps to set the database size limit using SQL Management Studio.
- Login to your SQL Management Studio.
- Right click on particular database and choose “Properties” option.
- A new dialogue will open where you have to choose “Files” option.
- You have to click on three dots which is under “Autogrowth / maxsize”.
- A new dialogue box will open “Change Autogrowth”.
- Check the box “Enable Autogrowth” option, set the maximum database size according to your need.