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 SQL Server 2012 Download and T-SQL Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.




download SQL Server 2014



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 Denali CTP3

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

SQL Server 2012 Compability Level 110, Denali

SQL Server Denali 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 Resources

SQL Server Articles

SQL Server 2012

SQL Server Tools

SQL Blog

SQL Server 2008 Blog

Certification Exams Blog

Reporting Services Blog

Analysis Services Blog

MS SQL Server Forums



Free Exam Vouchers










Copyright © 2004 - 2014 Eralper Yilmaz. All rights reserved.
Community Server by Telligent Systems