Error 1810

Severity Level 16

Message Text

CREATE DATABASE failed because of incorrect size parameter(s). Total number of megabytes specified must be at least %d megabytes so that the Model Database can be copied to the new database.

Explanation

This message occurs when you try to create a database that is smaller than the model database. The default is 1 MB.

Action

Make sure that the size you plan to use in the create database statement is greater than or equal to the size of the model database. Use the sp_helpdb system stored procedure to check the size of model. Type:

sp_helpdb model
go

When you issue the CREATE DATABASE statement, SQL Server makes a copy of the model database, which contains the system tables needed by each database. You can update model just like any other database, and add your own tables, stored procedures, datatypes, and so on. Whatever you add to the model database will be copied into each new database you create.

For more information, see the CREATE DATABASE statement in the Microsoft SQL Server Transact-SQL Reference.