How to Alter the model Database

Because the model database is created at the same time as the master database, no action is needed to build it. If you have made any changes to model, however, you must reapply them.

If you need to alter the size of the model database, alter the size of the tempdb database so that it is at least as big as model. If you attempt to start Adaptive Server, and model is bigger than tempdb, Adaptive Server will not start.