From the course: Installing SQL Server 2012

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Connecting to a database

Connecting to a database - SQL Server Tutorial

From the course: Installing SQL Server 2012

Start my 1-month free trial

Connecting to a database

In a previous video, we've seen how to create a database from scratch. Often times, you'll find that a database already exists, and when you install SQL Server, you'll want to bring that database into the SQL Server installation. This is known as attaching a database. And attaching a database is a quick and simple way of adding a new database to your SQL Server instance. The database that we were going to use in this example, is the AdventureWorks database that is freely downloadable from Microsoft's Codeplex site. In order for you to download the database, visit the URL that you see on the screen. This is where you'll find the AdventureWorks database sample products, that you can download and attach to your SQL Server installation. Attaching the AdventureWorks database to your SQL Server installation is a great way for you to use a database that already contains data, allowing you to explore the database, see how the information is stored in the tables and execute queries against it.…

Contents