Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

804


Part V: Enterprise Data Management


FIGURE 31-2
SQL Database Manager.

Another benefi t of this tool is that you can also author and execute queries directly within
the SQL Database Manager. Actually, you can do nearly everything in SQL Database Manager
and not need Management Studio. Awesome.

Creating a Database in SQL Database
In this section you’ll create a database using SQL Server Management Studio because you’ll
need it later in the chapter. Creating a database is pretty easy even though there isn’t a
wizard or dialog to help. So, open up SQL Server Management Studio in SQL Server 2012 and
in the Server Connection dialog, enter the Fully Qualifi ed Server Name of the SQL Database
server and your username and password.

c31.indd 804c31.indd 804 7/31/2012 10:00:23 AM7/31/2012 10:00:23 AM


http://www.it-ebooks.info
Free download pdf