SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


Create Database in SQL Server 2012 using SQL Server Management Studio


SQL Server 2012 database administrators or T-SQL programmers can create database in SQL Server 2012 using SSMS (SQL Server Management Studio) easily using the New Database wizard.

Open SQL Server Management Studio (SSMS).
Connect to the SQL Server 2012 database instance you want to create sql database in.
In Object Explorer window, drill-down through Databases node.
Right-click on display context menu.
Choose "New Database..." from task list

SQL Server Management Studio Object Explorer window New Database task

New Database wizard is displayed on the screen in order to create database in SQL Server 2012.

Provide the database name
Choose an owner schema, or leave for default "dbo"

The database file properties are offered default by SQL Server Management Studio
The database files are default placed into Data folder of the related Microsoft SQL Server instance installation folder.

New Database wizard in SQL Server 2012

SQL Server setup administrators can define the Autogrowth and Maximum File Size properties by using the "..." buton

If you want SQL Server handle file extend tasks you can mark "Enable Autogrowth" checkbox. In this case, administrators can define the file growth in percentage or in Megabytes sizes.

It is also possible to set a maximum file size. Or you can leave it as "Unlimited"

file growth and maximum file size properties of new database

Here is a huge list of new SQL Server database options SQL Server administrators can configure

new database options in SQL Server 2012 CTP3

Please note that the SQL Server compability level is 110 for SQL Server 2012 aka Denali

SQL Server 2012 Compability Level 110, Denali

SQL Server 2012 CTP1 has a Contained database feature.
Here is where setup administrators define that a database will be a SQL Server contained database or not. Containment type can be set as None (default) or Partial. Full containment database type is expected in future versions.
If you choose containment type Partial, then you create a contained database.

SQL Server 2012 database containment type

The last configuration step to complete creating a database in SQL Server is defining the sql database filegroups.

SQL Server database filegroups



SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.